Ask Question Sign In Sign Up

How to round numbers and remove 0 in SQL

Member

by zora.stokes , in category: SQL , 9 months ago

How to round numbers and remove 0 in SQL

1

SELECT REPLACE(RTRIM(REPLACE(REPLACE(RTRIM(REPLACE(LTRIM('  850.0000'),'0',' ')),' ','0'),'.',' ')),' ','.')


Facebook Twitter LinkedIn Telegram Whatsapp Pocket

no answers

Related Threads:

Nice way to generate SQL query in Python
Great approach to remove all numbers from a string in PHP
How to check password validation in javascript
Design Product Table in SQL when you don't know how is foreign keys works in SQL
Nice example how to use When and Case in SQL
Is Number function in SQL