trim leading zeros in sql
snippet in sql

trim leading zeros in sql

user5324

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