Sunday, March 9, 2014

MS SQL Server How to implement LPAD as in Oracle

select REPLICATE('0', 4 - DATALENGTH('234')) +'234'

Share Article : MS SQL Server How to implement LPAD as in Oracle
Share/Save/Bookmark
Posted by Srinath Gamage at 9:11 PM

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)