ENDS_WITH

​

Syntax

​

Scalar

ends_with(value, search)

​

Arguments

​

Returns

• Type: BOOLEAN
• Possible values: TRUE or FALSE from a case-sensitive literal substring comparison.
• NULL behavior: Returns NULL if either argument is NULL.

​

Properties

​

Examples

​

Typical behavior

SELECT ends_with('abc', 'bc') AS found, ends_with('abc', '') AS empty_search;

​

Case-sensitive suffixes

SELECT ends_with('report.csv', '.csv') AS csv_file, ends_with('report.CSV', '.csv') AS different_case;