Ask Question Sign In Sign Up
Home
Sign In
Sign Up
  • Home
  • >
  • SQL
  • >
  • How to round numbers and remove 0 in SQL
PHP JavaScript C/C++ Golang Java Python SQL Ruby Kotlin Swift Other
Category
PHP
JavaScript
C/C++
Golang
Java
Python
SQL
Ruby
Kotlin
Swift
Other

How to round numbers and remove 0 in SQL

Member

zora.stokes

by zora.stokes , in category: SQL , a year 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

About us

  • Contact us
© 2023 Copyright: crapcodes.com

This Site is Created By mywebforum.com

Get Your Own Questions & Answers platform