Archives of the TeradataForum
Message Posted: Fri, 06 Feb 2009 @ 10:01:49 GMT
<-- Anonymously Posted: Fri, 6 Feb 2009 09:52 -->
i'm trying to run a query selecting from a table with a not in clause. some of the statements that i want in the not in clause have quotes around one word, this is giving problems when i run the query.
where StatementText not in ( 'SELECT InfoData FROM dbc.dbcinfo where InfoKey ='release'' )
I'd appreciate if anyone could advise how to get around that
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|