lpad, rpad
On this page
Pads a string to a target character length.
Syntax
lpad( <expr>, width => <length> [, pad => <pad_string> ] )
rpad( <expr>, width => <length> [, pad => <pad_string> ] )Arguments
<expr> is a string expression.
width is the target character length.
pad is the string used for padding. If omitted, ScopeDB pads with spaces.
Returns
Returns a string. If the input is longer than width, the result is truncated to width characters.
Examples
SELECT lpad('42', width => 5, pad => '0'), rpad('db', width => 5, pad => '.');