Question
Still trying to find correct String Function for form search?
A user enters first 3 letters of a word on a search form- the
results need to include words which begin with them (e.g. "con"
returns "Conajoharie" - not case sensitive).
Using MS Access.
SELECT myword
FROM theDB
WHERE upper(substr(myword,1, 3) = <cfqueryparam value="#ucase(form.keyword)#">
or
WHERE myword LIKE <cfqueryparam value="#form.keyword#*"> don't work
or
WHERE myword LIKE '%#form.keyword#' don't work
no luck so far...
Any help appreciated.
Using MS Access.
SELECT myword
FROM theDB
WHERE upper(substr(myword,1, 3) = <cfqueryparam value="#ucase(form.keyword)#">
or
WHERE myword LIKE <cfqueryparam value="#form.keyword#*"> don't work
or
WHERE myword LIKE '%#form.keyword#' don't work
no luck so far...
Any help appreciated.
AdChoices