I'll explain better. There are 10 fields, Name is one of them. Instead of searching the table for a matching Name, I want to search the table for anything the user enters. ex. if one enters a name, it will query all fields and display the record that contains that name irregardless of what field it's in. I guess you might say that all of the data in the entire table needs to become one big text string and we then query for one specific field within that string. This would also hold true if one entered a serial number or network name etc. The query would simply search all the fields for a match. I've done this with string manipulation but now I'm doing it within a dbgrid and need to search with an sql statement. Yes / No ?

Thanks,

Kim

[Edited by casox on 03-31-2000 at 12:08 PM]