SQL search for any field

can someone tell me the SQL code to search for any value in any field in a table?
i tried :
Select * from table WHERE * LIKE '*'& [ enter search] & '*';
it doesn't work. plz help.
thank you.

This would actually be pretty difficult to do. First you have to determine your table, then you have to loop through all the fields in that table, then you have to run the query to search each field in the table for the criteria.

For performance reasons this isn't recommended at all. That's why you always see a field designated in searches.