Available in versions: Dev (3.19) | Latest (3.18) | 3.17 | 3.16 | 3.15 | 3.14 | 3.13 | 3.12 | 3.11 | 3.10 | 3.9
RPAD
Applies to ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
The RPAD() pads a string at the right end. See also LPAD.
SELECT rpad('hello', 10, '.');
create.select(rpad(val("hello"), 10, '.')).fetch();
The result being
+------------+ | rpad | +------------+ | hello..... | +------------+
Dialect support
This example using jOOQ:
rpad(val("hello"), 10, '.')
Translates to the following dialect specific expressions:
-- ACCESS
('hello' & replace(space(10 - len('hello')), ' ', '.'))
-- ASE
('hello' || replicate(
'.',
(10 - char_length('hello'))
))
-- AURORA_MYSQL, AURORA_POSTGRES, COCKROACHDB, DB2, FIREBIRD, H2, HANA, HSQLDB, INFORMIX, MARIADB, MEMSQL, MYSQL, ORACLE,
-- POSTGRES, TERADATA, VERTICA
rpad('hello', 10, '.')
-- SQLDATAWAREHOUSE, SQLSERVER
('hello' + replicate(
'.',
(10 - len('hello'))
))
-- SQLITE
'hello' || substr("replace"(hex(zeroblob(10)), '00', '.'), 1, 10 - length('hello'))
-- SYBASE
('hello' || repeat(
'.',
(10 - length('hello'))
))
-- BIGQUERY, DERBY, DUCKDB, EXASOL, REDSHIFT, SNOWFLAKE, TRINO, YUGABYTEDB
/* UNSUPPORTED */
(These are currently generated with jOOQ 3.19, see #10141), or translate your own on our website
Feedback
Do you have any feedback about this page? We'd love to hear it!