it is used to check NULL or NOT NULL values.

Syntax:

Like OPerator

Used to check whether a column has data starts/ends with specific word

Escape char

used to convert wild card character into special character