Adding filter criteria in Dynamos

[peprdcs]

Hi ,
I am not able to add a filter criteria to a sql query of a dynamo in a powerprompt application. Can somebody please help me out with this ?
The query is as follows :

Dynamo.SQL='SELECT DISTINCT "DCS"."DCFI"."CONTRACTOR_NBR", "DCS"."DCFI"."CONTRACTOR_NBR" FROM "DCS"."DCFI"';

I need to add the following filter criteria :

WHERE "DCS"."DCFI"."CONTRACTOR_NBR" IN '03','04,'05'

I get a problem with all the single quotes that I use in the where clause.

Thanks in advance ..

 

[griffindm]

An IN clause in SQL requires leading and ending parentheses around the values.

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com