Contains

contains is used to check membership. It is index-based and word-oriented.

It is used for clob data type, on larger pieces of text.

It is much more powerful (also includes ranking)

It is also faster than like in many cases because it uses index

However, we must build the index first (create index … )

Example:

SELECT * FROM Table WHERE CONTAINS(name, 'Vikram', 1)>0;