Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 16 Feb 2005 @ 14:32:00 GMT


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


Subj:   SQL Assistant and search for ???
 
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, February 16, 2005 09:30 -->

I'm trying to write a query to search for ??? in our data - and I'm getting an interesting pop-up box asking me for the value of the parameter. Several months ago - I had a problem with question marks in our queries blowing up SQL server and a VB application (using ADODB through ODBC), and I think this might be related. Is there a way I can tell teradata that the question marks are literals rather than placeholders for parameters?

     select lpa_mkt_screen_desc, lpa_mkt_code as mkt_chnl_code
       from dscpav02.vscpa_market_code_sel
       where lpa_mkt_code <> '?????'
       order by lpa_mkt_screen_desc

Thanks!



     
  <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