Hi.
I want to select from avtable , based on a Parameter (Say X)
e.g. If Parameter = Blank, select all records, else select where a Filed eqauls parameter value

In VFP, following works:
SELECT * FROM MyTable WHERE IIF(X= " ",.t.,REF == X)

Can something similar be done in Sql (Above simplified version... I could have 5 Where conditions)
Tia
Gerard