>If I had a numeric value of 1.4476, how can I convert this to character and make it look exactly like
>numeric value ("1.4476"). whenever I do following I get just 1 character rounded up or down:
>
ct = 1.4476
x = str(ct)
?x
>I need it to show "1.4476"
Besides the TRANSFORM() suggested elsewhere, you could use
x = LTRIM(STR(ct, 10, 4))