Show all Hide all

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

Type: Scalar function
Area of use: General use

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.