ENDS_WITH

Returns TRUE if a string ends with a specified suffix.

Signatures

Returns: TRUE if string ends with suffix, FALSE otherwise

ENDS_WITH(string: VARCHAR, suffix: VARCHAR) → BOOLEAN

sql

Parameter	Type	Required	Description
`string`	`VARCHAR`	Yes	String to check
`suffix`	`VARCHAR`	Yes	Suffix to look for

Notes

Case-sensitive comparison
Returns FALSE if suffix is longer than string
Returns TRUE if string and suffix are identical

Examples

FeatureQL

SELECT
    f1 := ENDS_WITH('Hello World', 'World'),  -- Ends with suffix
    f2 := ENDS_WITH('Hello World', 'world'),  -- Case-sensitive
    f3 := ENDS_WITH('Hello World', 'World'),  -- Ends with suffix
    f4 := ENDS_WITH('test', 'test'),  -- Exact match
    f5 := ENDS_WITH('ting', 'testing'),  -- Suffix longer than string
    f6 := ENDS_WITH('100€', '€')  -- Unicode suffix
;

Result

f1 BOOLEAN	f2 BOOLEAN	f3 BOOLEAN	f4 BOOLEAN	f5 BOOLEAN	f6 BOOLEAN
true	false	true	true	false	true

Suggest changes to this page

Last update at: 2026/03/03 16:47:38

On this page

Signatures Notes Examples