Show all Hide all


Pads a character string from the right 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)
The character to use for padding.