ENDS WITH

​

<expression> ENDS WITH <value>

​

Description

Evaluates to True if the value returned by <expression> has <value> as a substring at the end. <expression> can be <table>.<column> or AGG(<table>.<column>, <start>, <end>).

This operator can only be applied to text columns.

​

Example

MOVIE.TITLE ENDS WITH 'Rings'