Can anyone tell me how to search all fields in an SQL statement as opposed to just one? This is the code I want to change.

strQuery = "SELECT * FROM software WHERE Name LIKE '%" & SoftwareString & "%'"

I want to do a text search on all of the fields, not just the Name field. Thanks.

casox