Type: Scalar function

Pads a character string from the left using the specified padding character to the specified length.

Return value: nvarchar(max)

The padded character string.


@s mandatory varchar(8000)
The string to be padded.
@length mandatory int
The length which to pad the string.
@padchar mandatory char(1)
Character to use for padding.