Archives of the TeradataForum

Message Posted: Mon, 09 Feb 2004 @ 15:57:44 GMT

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

The "?" is usually a NULL value. Change the SQL as follows...

SELECT  "col1" , "col2"
FROM    "PROD"."View1"
WHERE   ( "col2" is NULL ) ;

Sometimes a ? is also used as a parameter and so the SQL not complete is because MS Access is looking for a value to replace the ?....

Hope this helps...

Best Regards

Chris Coffing
AFKS O&M Lead Teradata DBA
Certified Teradata Master

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