Archives of the TeradataForum
Message Posted: Fri, 07 Jan 2005 @ 17:47:58 GMT
| Subj: | | Re: "NOT LIKE ANY" |
| |
| From: | | Anomy Anom |
<-- Anonymously Posted: Friday, January 07, 2005 11:17 -->
I think this is a bug in the Teradata SQL (Not sure though).. May be the SQL Standards are that way...
I have tried the LIKE function with IN operator as you have tried with the ANY operator. It just don't work...
Anything given in a list is treated as a string-constant instead of a regular-expression.
-- BTW, the listed data shows 'CENTAL' not 'CENTRAL' ...
| 
