Archives of the TeradataForum

Message Posted: Fri, 06 Feb 2009 @ 12:05:41 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

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?

Victor