SQL Search Statement 1

[IndyGill]

Hi

I am creating an ASP search page which searches through a field (description) and pulls out and words that meet the search criteria. I am using the following SQL statement

"SELECT * FROM directory where description like '%" & Replace(find, "","&quot & "%'"

However I also want it to search another field in the database (businessName)at the same time, but I am having trouble writing the SQL statement. I am new to SQL so I would be grateful for any help.

Many thanks

Indy

 

[link9]

"SELECT * FROM directory where description like '%" & Replace(find, "","&quot & "%' OR theOtherField like '%" & replace(find, "","&quot & "%'"