Archives of the TeradataForum
Message Posted: Wed, 16 Feb 2005 @ 14:32:00 GMT
| 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
select lpa_mkt_screen_desc, lpa_mkt_code as mkt_chnl_code
where lpa_mkt_code <> '?????'
order by lpa_mkt_screen_desc