|
Displaying Source Code(s)
|
|
What is wrong with 'LIKE *'?
--------------------------------------------------------------------------------
ADO uses % for wildcard translation, not *. Therefore, if you
use * as a wildcard, the query will actually be searching for
records that have a literal * in the field data. Also, you
should use _ instead of ?. Access natively supports % and _ (in
addition to * and ?), so it is recommended to use those
everywhere instead of being forced to worry about statement
conversion when web-ifying anything.
--------------------------------------------------------------------------------
|
|
|
123
Eng