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.
Parameters
@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.