Hello,

I'm working on a project where I want to search multile fields in a table based on user input. Is there a way to combine these fields in my SELECT statement (with an AS clause) so I can only do a WHERE clause on one field?

For instance, if I have a firstName and lastName field and I want to search by full name, I want to do something like:
Code:
SELECT (firstName & ' ' & lastName) as fullName WHERE fullName LIKE '%lee%';
...and have it pull both "Lee Jones" and "Bruce Lee".

I know that I could search both fields using an AND joiner, but I'm talking about 10 fields or so, and I'd like to just be able to join them into one search field.

Any ideas?

Thanks,
Goof