Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Query with NOT IN and quotes
From:   Anomy Anom

<-- 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>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016