tsql remove leading zeros in a string that is 10 characters in length
SUBSTRING([TheString], patindex('%[^0]%',[TheString]), 10)
Wednesday, May 11, 2011
Subscribe to:
Post Comments (Atom)
Achievement provides the only real pleasure in life
SUBSTRING([TheString], patindex('%[^0]%',[TheString]), 10)
Posted by
SF
at
11:44 am
No comments:
Post a Comment