|
|
|
Forum Newbie
Group: Forum Members
Last Login: 1/31/2006 4:13:00 PM
Posts: 3,
Visits: 1
|
|
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.
Thanks in advance!
DD
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 6/12/2008 3:32:33 PM
Posts: 4,
Visits: 48
|
|
DD
In Teradata your example would be:
SEL * FROM emp WHERE empnm LIKE 'dd%';
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 10/31/2006 11:05:00 AM
Posts: 1,
Visits: 1
|
|
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.
Suvomoy Chakraborty
“Save Trees, Save the Earth
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 7/3/2008 11:03:47 PM
Posts: 41,
Visits: 5
|
|
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
|
|
|
|