[Itanium]

select * from table
where col1 = 'value1' and
col2 = 'value2' and
col3 = 'value3';

this should be the query if all the columns are holding string data.
If any column is holding numeric data, then you dont need to specify the value within quotes.

Can you post your exact code for us to analyse ?