Archives of the TeradataForum

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

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

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