I have my search working nicely, but noticed the following:
search for city of 'fort lauderdale' and it returns the 5 results with 'fort lauderdale' entered as the field value. Why doesnt it return the entries that have 'ft lauderdale' and 'Ft. lauderdale'?
my query line is pasted in code below:
AND tbl_cs_seeker.skr_citySeek LIKE <cfqueryparam value="%#form.sr_city#%" cfsqltype="cf_sql_varchar">