"Contains" and "Not Contains" methods in SQL or by using Java script UDF

Question

Can we use "Contains" and "NotContains" methods in SQL i.e., How do I check if a string or a column value is contained in another column of a table.

Problem Statement:

How do I check if a string "ABC" is contained/Not contained in "Column1"
How do I check if a "Column1" value is contained/Not contained in "Column2"

If not SQL can we use JavaScript UDF or any other means to make this happen?

Does this answer your question? [SQL SELECT WHERE field contains words](https://stackoverflow.com/questions/14290857/sql-select-where-field-contains-words) — Robert Harvey, Sep 04 '21 at 16:56
I am looking for a function which can be used in a case statement — ADom, Sep 04 '21 at 17:10
Why do you want to use a function when a simple SQL command solves the problem? — NickW, Sep 04 '21 at 18:30

Lukasz Szozda · Accepted Answer · 2021-09-05T02:21:45.677

CONTAINS:

Returns true if expr1 contains expr2. Both expressions must be text or binary expressions.
CONTAINS( <expr1> , <expr2> )

Examples:

SELECT * FROM tab WHERE (Colum1, 'ABC');
SELECT * FROM tab WHERE NOT (Colum1, 'ABC');

SELECT * FROM tab WHERE (Colum1, Column2);
SELECT * FROM tab WHERE NOT (Colum1, Column2);

It is worth mentioning Snowflake LIKE/ILIKE [ANY]:

SELECT *
FROM tab
WHERE Column1 LIKE ANY ('%ABC%','%XYZ%');

score 0 · Answer 2 · answered Sep 04 '21 at 21:59

You can use Like operator I believe i am not sure what exactly are you looking for but here is an example below. For more details: https://www.w3schools.com/sql/sql_like.asp

select column
from [table]
where column Like %ABC%

or if you already know the values that you are looking for in a specific column then you can use in operator:

select column from [table] where column in ('ABC','XYZ')

This will give you the rows for the column, where the values are equal to either ABC or XYZ

"Contains" and "Not Contains" methods in SQL or by using Java script UDF

2 Answers2