What is the proper syntax for: WHERE strIng CONTAINS strSearch

Normally, I'd set a "Contains" filter on my str开发者_运维问答ing field, and enter my value in the modal box, but I want to audit the process.

UPDATE Data SET Data.[Assumed Expires]=Data.[Assumed Expires]+365 WHERE Data.[Description]=strSearch;

Thanks a pile!

I can't remember Access syntax exactly, but something like this to do a substring match:

WHERE Data.[Description] like '*' & strSearch & '*';