DEV Community

Discussion on: Recreating MYSQL's LPAD Function in SQL Server

Collapse
 
jamiemcmanus profile image
Jamie Mc Manus

I don't think it replicates the functionality but its close !

The problem is RIGHT will truncate the leftmost characters of the dummy string , while LPad in mysql will truncate the characters on the right of the dummy string but before the original string