I have an Access DB I'm running a query search on (from a search page) works fine (well sort of).
Example: If I enter "company" in the search field it will find any record with just the word company, what I need it to find is any record with the word company any were in the search field (IE: my company).
I know in access you can use * as a wildcard (IE "*"& [rsSearch__MMColParam]&"*") would find both "company" and "my company".
Is there a way to do this
** part of current code **
rsSearch__MMColParam = "1"
If (Request.QueryString("search_field") <> "") Then
rsSearch__MMColParam = Request.QueryString("search_field")
Set rsSearch = Server.CreateObject("ADODB.Recordset")
rsSearch.ActiveConnection = MM_BLOCK_STRING
rsSearch.Source = "SELECT * FROM Salesleads WHERE Company = '" + Replace(rsSearch__MMColParam, "'", "''") + "' ORDER BY CallDate ASC"
rsSearch.CursorType = 0
rsSearch.CursorLocation = 2
rsSearch.LockType = 1
Thanks for any help in advance
To learn is a good thing and today I hope to learn something new!