Lets say I have a dbase and in my table I have a record FirstName Richard, LastName Rost, and Alias Rick.  In my search I don't know if you are under Richard Rost or Rick Rost...
Is there a line of code I can use to also search for the alias so however the search is done your record comes up???  Meaning if its under Richard Rost and I type Rick it wont come up.  And I don't know if the data entry person entered you in as Richard or Rick when making your file.

---

Reply from Richard Rost:

Sure. Just have your SQL statement look in multiple fields.

SELECT * FROM CustomerT WHERE (FirstName="Rick" OR NickNake="Rick")

Then use this as the basis for your search results form, as I show in the SEARCH SEMINAR.