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

0 comments:

Post a Comment