If you have ever used Oracle and needed to create a string padded with zero’s, they have a nifty function called LPAD which allows you to do this easily. In SQL Server we need to create our own way.
If you have ever used Oracle and needed to create a string padded with zero’s, they have a nifty function called LPAD which allows you to do this easily. In SQL Server we need to create our own way.
Jim Salasek's SQL Server Blog 