searching my database with wildcards
I designed a web application and i used the code below to search through the database,but i have a problem , if i search for bsc, it gives it's results, if i search for b.sc it will only give me search results for those that inputed b.sc , how do i improve my codes to also take care of ( . )
if strQualification <> "" then strCriteria = strCriteria & strSearchMode & "(Qualification LIKE '%" & LCase( strQualification) & "%')"
|