Is it possible to combine an if statement with sql...example:

if x=y then
SELECT *
FROM tbl_comp
else
SELECT *
FROM tbl_comp
Where x<>y

Hello,

in which context. In PL/SQL on Oracle ... in general ... on MS SQL Server ... ????

Regards
Manfred Peter
(Alligator Company)
http://www.alligatorsql.com

It is actually MS Access 97, in the QBE Grid.

I would not think it suports any PL/SQL at all

What you need cannot be accomplished in the QBE grid, but you can write a code module that will allow you to do what you need. Check the help and take a look at the SELECT CASE command.

Hope it helps,
j-Dog