rpad()

Pads the string with the character from the right until it has 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 DuckDB
SELECT RPAD('data', 8, ' ')

SQLGlot example ↗