Teradata Forums / Analytical Applications / Teradata / Teradata function equivalent to 'LIKE %..%' in Teradata / Latest Posts

RE: Teradata function equivalent to 'LIKE %..%' in Teradata

ANGEL — Tue, 21 Mar 2006 23:58:14 GMT

Hi,

We can use ESCAPE to locate a wildcard character.

For example

SELECT TABLENAME FROM DBC.TABLES
where tablename like ('-------\_%)' ESCAPE '\'

This will return all tables where '_' is in eighth position.

Hope this helps

Thanks
Angel

RE: Teradata function equivalent to 'LIKE %..%' in Teradata

suvomoy — Tue, 21 Mar 2006 08:57:44 GMT

Hi all,

Can we try same kind of pattern matching involving "LIKE" operator when i am looking for a special character like '_'.

As the 'instr' function does not work with Teradata (Upto my knowledge) the only workaround is using the 'substr' on multiple occasion to match the special character.

A solution is badly needed.

RE: Teradata function equivalent to 'LIKE %..%' in Teradata

BoB — Tue, 31 Jan 2006 22:49:33 GMT

DD

In Teradata your example would be:

SEL * FROM emp WHERE empnm LIKE 'dd%';

Teradata function equivalent to 'LIKE %..%' in Teradata

ddpp — Tue, 31 Jan 2006 16:16:35 GMT

Hi all,
Can anyone please let me know A teradata function which is equivalent to LIKE in Oracle.

Eg. Select * from EMP where empnm=like'dd%' in oracle database

Please write in Teradata

Please respond ASAP.