ENDSWITH

​

Syntax

​

Scalar

endswith(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 endswith('abc', 'bc') AS found, endswith('abc', '') AS empty_search;

​

Case-sensitive suffixes

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