How to remove the trailing dynamic zeros for the given numbers in MS-SQL server

Question

Given value in database table is 23.045000,45.6090, 23.900 . Output should be displayed as 23.045, 45.609, 23.9

Can you be more specific about which "output" you're asking? The result of an SQL query or some tool that you use to view the database? — Viktor Seifert, Dec 05 '17 at 09:48

score 0 · Answer 1 · answered Dec 05 '17 at 09:49

0

Cast the value as Float. like this

select cast(23.045000 as float)-->23.045
select cast(45.6090 as float)-->45.609
select cast(23.900 as float)-->23.9

answered Dec 05 '17 at 09:49

1 Answers1