String to decimal conversion problem
Posted: Mon Sep 20, 2010 1:21 am
Hi
I have source varchar(255) value 123456789123456789 , i am trying to converting this varchar to decimal (18.2) , but i am unble to converting.
I am getting output like all zeros.(0000000000000000.00 )
Any suggessions
Thanks in advance
I have source varchar(255) value 123456789123456789 , i am trying to converting this varchar to decimal (18.2) , but i am unble to converting.
I am getting output like all zeros.(0000000000000000.00 )
Any suggessions
Thanks in advance