Search all fields

Hi,

Using MSAccess
Situation:
End user gives a string input.
This string may exist in any field.
How to do this?

My possible sollutions:
1.
SELECT * FROM tabel WHERE filename='string' OR field2='string' OR field3='string' etc.... (long....)

2.
SELECT *, Filename & " " & field2 & " " & field3 (etc..) AS everything WHERE everything LIKE "%string%";

Both these "sollutions" require a very long SELECT query since my tabel has many fields

Isn't there an internal function to select all fields at once and combine them?

Thanks,
Maarten