开发者

What is the proper syntax for: WHERE strIng CONTAINS strSearch

开发者 https://www.devze.com 2023-01-20 11:31 出处:网络
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.

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 & '*'; 
0

精彩评论

暂无评论...
验证码 换一张
取 消