| Access | ||
|
The "brute force" method is to use use the LIKE operator against any of the
fields to be searched. This will be relatively expensive - but probably
good enough in many cases. The term to search for should be quoted and
placed within two wild cards. You should construct the string literal in some scripting language - don't forget to quote it. | ||
| Specific to Access | ||
| String comparison in Access is alway case insensitive. | ||