Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

trim leading zeros in sql

SUBSTRING(str_col, PATINDEX('%[^0]%', str_col+'.'), LEN(str_col))
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #trim #leading #zeros #sql
ADD COMMENT
Topic
Name
9+5 =