Jim Lawrence (AccessD)
accessd at shaw.ca
Mon Jul 26 14:58:15 CDT 2004
Mark select * from myTable where myFieldName like *Mark* The previous sql should return all matches, from table myTable where the word 'Mark' is anywhere in the field myFieldName. HTH Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Mitsules, Mark S. (Newport News) Sent: Monday, July 26, 2004 11:38 AM To: [AccessD] Subject: [AccessD] Multiple Table Search Group, Strange request, but I've been handed this db and am not familiar enough with the data to do an educated search. What is the simplest method to find an instance of data amongst 70+ tables. Mark -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com