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.
SELECT <column_list> FROM <table_name> WHERE <column_name> LIKE ‘% [character(s) to search]%’