Searching more than 1 field from a form

[Anon]

Hello community!

I would like to construct a SELECT statement as so...

SELECT * FROM tableName where firtName = 'Suzy'
AND
lastName = 'All'
AND
Country = 'USA'
AND
State = 'All';

My question is how do I represent 'All'?
Thanks in advance,
FunkyFresh!

[Anon]

Funky,

You just omit the All statements.

SELECT * FROM tableName where firtName = 'Suzy' AND Country = 'USA'

will do unless All is actually an entry in the field in the database. If you by all mean 'all values', this is obtained by not setting up any selectors for that field.

Martin

[Anon]

Thanks Martin