Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

sql server remove 0 from left

  SUBSTRING(str_col, PATINDEX('%[^0]%', str_col+'.'), LEN(str_col))
 
PREVIOUS NEXT
Tagged: #sql #server #remove #left
ADD COMMENT
Topic
Name
1+5 =