[skyshare]

I have an access table with 20 fields with a VB6 connection. Is there a way to search all fields in the table for an item of text without referencing each field individually?


I am trying to avoid the following...

Select * from <tablename> where field1 ='text' or field2 = 'text' or field3='text'....etc


thanks

[maj3091]

You might be better asking a mod to move this to the database forum, as I think you're looking more at a SQL question than a VB one.

[modi123_1]

Please avoid opening duplicate topics. If you needed this moved click the 'report' button and type in where you need a mod to move it.