on 09-24-2010 6:45 PM
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
Hi,
the function FIXED (<your expression>, <number of digits) may help
Elke
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.