cancel
Showing results for 
Search instead for 
Did you mean: 

result in scientific notation

Former Member
0 Kudos

Hi,

We migrated an instance from 7.3 to 7.6 x64 (no unicode) and I get an expression result in scientific notation.

How can I make the notation use decimal? I cannot find anything in the documentation.

sqlcli

EXPRESSION1


1.3192E7

1 row selected (449 msec)

Cheers,

Jan

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

the function FIXED (<your expression>, <number of digits) may help

Elke