SUJOY SANTRA
Tuesday, 6 October 2015
How to remove leading 0 in SQL
Remove leading 0 in SQL:
select substring(ColumnName, patindex('%[^0]%',ColumnName), len(
ColumnName
))
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment