Archives of the TeradataForum
Message Posted: Fri, 07 Jan 2005 @ 17:47:58 GMT
<-- 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' ...
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|