Home Page for the TeradataForum

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?


  <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