Posted By
Ashok Generally in MS Access we use
LIKE operator with '
*' character for easy search. But when working with
VB 6.0 or VB .Net coding with
ADO it will not work if we use '
*' character. We should replace the '
*' character into '
%' character. Then only it will work.
But, if we use '
%' character directly in MS Access, it will not display any query results even the formed query is correct. There we should use '
*' character. Only in
VB 6.0 or VB .Net coding with
ADO, '
*' character should replace '
%' character.
ExampleSELECT <column_list>
FROM <table_name>
WHERE <column_name>
LIKE '% [character(s) to search]%'
