Answers for "sql remove trailing zeros"

SQL
1

trim leading zeros in sql

SUBSTRING(str_col, PATINDEX('%[^0]%', str_col+'.'), LEN(str_col))
Posted by: Guest on January-20-2021
0

sql server remove 0 from left

SUBSTRING(str_col, PATINDEX('%[^0]%', str_col+'.'), LEN(str_col))
Posted by: Guest on April-23-2021

Code answers related to "sql remove trailing zeros"

Code answers related to "SQL"

Browse Popular Code Answers by Language