convert exponential value to string

[JenJohnson]

I have a table with a float column, and one value in this column is

"0.000098940869229982722"

.

When I try to convert this value to a string, I get

"9.8940869229982722e-005"

.

I don't want to see the exponential notation, but I do want to see all the decimal places. I tried using the

exp

Sybase function, but (obviously) didn't retain the exact decimal places.

Any help would be greatly appreciated!
Thanks,
Jennifer

 

[VDavid]

Hi,
How are you converting the values?
Are you using CONVERT?

I tried with convert and the result was

.000098940869229982722

Without the starting zero, so use String('0',column).
Also if I use float, the values changes, I had to use double, I'm not sure, I guess it's because of the engine version of sybase.

Hope this helps,
David.

 

[JenJohnson]

It did help (sorry for the delayed response).
Thanks!

 

[VDavid]

No problem. Glad it helped.