Finda Data in multiple fields

[gizmo1973]

I have a single table with address details of my clients.
I want to search through three different fileds for the same word at one time, how would I go about this?
i.e. Find Manchester in Field names Address 1, Address 2, ect etc

Regards, Phil

"If in doubt, hit it with an end user!

 

[lespaul]

SELECT * FROM TABLE WHERE [ADDRESS 1] LIKE "*MANCHESTER*" OR [ADDRESS 2] LIKE "*MANCHESTER*" OR [ADDRESS 3] LIKE "*MANCHESTER*"

Leslie