Lpad In Sql Server. The way it works is that we pass. This string function adds the symbol or the string to the left side of the original string.

Sql (structured query language) (sql) arguments. Leftpad fills the left part of a string with another string, repeated several times, to make a new string with the length passed as parameter. Note that if the target_length is less than the length of the source_string, then lpad() function will shorten down the source_string.