LIKE

Database
Fan

LIKE

I am attempting to look for patterns in the data using like statements.  I do not know where in the text field I will find the pattern, I don't care about the position. How do I get teradata to recognize the difference between like "%click_" and only return rows that have click_ and not return clickstream?  Simple example below.

select databasename, tablename from dbc.tables where tablename like '%click_%'

2 REPLIES
Enthusiast

Re: LIKE

select databasename, tablename from dbc.tables
where tablename like '%clickx_%' escape 'x';

please check.

Br,

Arun 

Fan

Re: LIKE

Thank You