Removing pre zero from number :

select substring(Column, patindex('%[^0]%',Column), 10) from Table

Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)