Answers for "how to remove leading and trailing zeros in sql"

trim leading zeros in sql

SUBSTRING(str_col, PATINDEX('%[^0]%', str_col+'.'), LEN(str_col))

Posted by: Guest on January-20-2021

Code answers related to "how to remove leading and trailing zeros in sql"