Hi,

Is it possible to search all fields of all tables in a database with a single SQL statement, other than putting it together field by field and table by table?

John

You could use code to do this. That is a tall order. Why would you need to do this? Especially since some fields are presumably autonumber, date, currency, etc, and not just text. What sort of things do you need to find?

mmcdonal

Just to make it easier on the users. The project has 8 tables, lots of fields in each, and much of data could be possibly be in several places. I've already done it with code - just messy, and it created the mother of all SQL statements. Wanted to be sure I wasn't overlooking a simply, cleaner way.