Archives of the TeradataForum
Message Posted: Fri, 06 Feb 2009 @ 12:05:41 GMT
| Subj: || || Re: Query with NOT IN and quotes |
| From: || || Victor Sokovin |
| ||thanks for the below much appre - unfort that fails with a 3706 its matching up the first quote at the select with the first quote at
release - i've tried double quotes, brackets - i couldnt think of anything else|| |
| ||any other ideas would be most welcome|| |
> where StatementText not in (
> 'SELECT InfoData FROM dbc.dbcinfo where InfoKey =''release'''
You don't need the quote in front of the SELECT so try to drop it together with the closing one at the end of the subquery. Once that is
sorted, report whether you have more problems.
Wouldn't InfoKey ='release' be enough then?
What are you actually trying to achieve?