ends_with()

Returns true if string ends with search_string.

Alias of suffix()

Arguments & returns

ends_with(string, search_string)

Scalar
Overload link stringsearch_string Returns
#01 VARCHARVARCHAR BOOLEAN

Example

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

Engine example · Run to view results.

In other engines

Snowflakeendswith()

ENDSWITH('abc', 'c')
In DuckDB
ENDS_WITH('abc', 'c')

SQLGlot example ↗