Wednesday, 18 May 2011

Add leading 0 in zip code using update query in sql server

update tablename set zip='00'+zip where len(zip)=3
update tablename set zip='0'+zip where len(zip)=4
Posted by at

1 comment:

  1. jay4 July 2011 at 05:44

    thanks for this it is helpful for my sql knowledge

    ReplyDelete

Subscribe to: Post Comments (Atom)