How to show a number in scientific notation ?

Question

question

JPCOUTINHO asked Mar 29, '16

How to show a number in scientific notation ?

I need to know how to express a number in scientific notation by using SQL SELECT, Ex; need that the number 300 to be expressed as 3.0E+2. with one decimal place and in scientific notation DECLARE @Nr as float SET @Nr = 300 select convert(varchar(max),@Nr,2) Result is : 3.000000000000000e+002 Need it to be : 3.0E+2

sql

2

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Shawn_Melton commented · Mar 30, 2016 at 03:29 AM

This site is primarily hosted and monitored by English speaking users, please update your post.

0 ·

ThomasRushton ♦♦ commented · Mar 30, 2016 at 10:48 AM

This really sounds like something that should be done at the client side, rather than at the server side... But I'm sure someone will be along to help!

0 ·

Answer 1 · 2016-03-30T13:02:55Z

David Wimbush answered Mar 30, '16

If you have SQL Server 2012 or later you can do this with the format() function: declare @Nr as float = 300; select format(@Nr, '0.0E+0'); You can read more about controlling the format here: [ https://msdn.microsoft.com/en-us/library/0c899ak8(v=vs.110).aspx][1] [1]: https://msdn.microsoft.com/en-us/library/0c899ak8(v=vs.110).aspx

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

JPCOUTINHO commented · Mar 30, 2016 at 05:19 PM

Excelent...simple & efective tks a lot

0 ·

question