> I'm _Sorry_ for my poor English.
No worse than some native English speakers I could mention, so no apology
necessary. :)
> Simple code:
Whenever I've used LIKE in the past, I've never used parentheses around the
expression; it was always expressed as
SELECT foo FROM bar WHERE foo LIKE 'baz';
...granted, that's just on Oracle. Access might differ.
Have you tried it encapsulating each expression of your match in
parentheses, like below?
WHERE (vchTitle LIKE #PreserveSingleQuotes(sql_search_string)#)
OR (vchKeywords LIKE #PreserveSingleQuotes(sql_search_string)#)
OR (txBody LIKE #PreserveSingleQuotes(sql_search_string)#)
OR (vchDesc LIKE #PreserveSingleQuotes(sql_search_string)#)
HTH...HAND.
Brandon Whitaker
[EMAIL PROTECTED]
-------
"It'll get used by the same people using Opera. People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.