Normally, I'd set a "Contains" filter on my string 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!
views:
31answers:
1
+2
A:
I can't remember Access syntax exactly, but something like this to do a substring match:
WHERE Data.[Description] like '*' & strSearch & '*';
RedFilter
2010-10-13 15:12:13
That was it, thanks for the quick response!
NickSentowski
2010-10-13 15:14:31
The wild card can be % if you are querying through ADO or have set SQL Compatibility (ANSI 92).
Remou
2010-10-13 19:37:09