vb 2008 search in all fields

[markdean.expres]

Guys, how do I search for records using keywords from a textbox in all fields within my table (within my database).
I am only aware of filtering rows based on a single column value only

Thanks...

[thines01]

If you have your data in some type of structure -- 2d array, list of objects, etc, you can loop horizontally and vertically through the data until you find what you want.

The technique will partly depend on how much data you can pull back at one time and if you're searching for substrings or exact matches.

[M.Waqas Aslam]

you can do this by using query , can you please tell me about table and fields and on which fields you want to set you record selection criteria .

Regards