ENDSWITH
Returns TRUE if the first expression ends with second expression.
Syntax
ENDSWITH(column/expr, string)
Example
select * from
/shared/examples/ds_orders/tutorial/employees
where endswith(firstname, 'es')
The above query lists all the rows that have the firstname column ending with “es”.