Could you tell me how add after converting Char to Numeric .( in oralce ) I was readiing paper  (see below title  ), oracel won't save numeric  variable value with leading zero. Let me know your thoughts... Using SAS® with Oracle®: Writing efficient and accurate SQL ... View more

i think so , i will defiantly post  it. If i come up with come up some  thing... ... View more

I am using oracle . I change my mind, I will use SAS to accesses the oracle data. But still that conversion bugs me .( Char  to Numeric with leading zero  ) ....hopefully  I will figure out something.. ... View more

Sry.. I need to do it in TOAD. ... View more

@ patrick, Actually , I am joing two tables with 'key' varible. The key varible in one table it is numeric and in another it's charecter. So i need to convert char to numeric, During the converiosn i shoud not remove leading zeros. So i need help in adding leading zero's. Thanks for your hlep, ... View more

Hi ksharp, thanks for replay , I need the  "b" varible be numeric. your code gives in char varible after chnaging it. ... View more