Archives of the TeradataForum

Message Posted: Fri, 06 Feb 2009 @ 11:31:20 GMT

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

<-- Anonymously Posted: Fri, 6 Feb 2009 11:30 -->

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'''
          )

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