posted 21 years ago
ok, I got it now. it was simpler than I thought.
SELECT * FROM table where
((x = '') OR (x <> '' AND firstName >= x)) AND
((y = '') OR (y <> '' AND firstName <= y)) AND etc...
I shouldn't use null values, just use empty strings. That's probably why everyone that answered the question answered as you did.