Functions/Text & patterns/rpad
Text & patterns Scalar

rpad()

Pads the string with the character on the right until it has count characters. Truncates the string on the right if it has more than count characters.

Arguments & returns

rpad(string, count, character)

Scalar
Overload link stringcountcharacter Returns
#01 VARCHARINTEGERVARCHAR VARCHAR

Example

rpad example
SQL
Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

In other engines

Snowflakerpad()

SELECT RPAD('data', 8)
In Haybarn
SELECT RPAD('data', 8, ' ')

SQLGlot example ↗