lpad()

Pads the string with the character from the left until it has count characters

Arguments & returns

lpad(string, count, character)

Scalar
Overload link stringcountcharacter Returns
#01 VARCHARINTEGERVARCHAR VARCHAR

Example

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

Engine example · Run to view results.

Catalog examples

SELECT
  lpad('hello', 10, '>');