WHERE companynamecolumn LIKE <cfqueryparam cfsqltype="cf_sql_varchar" value="#FORM.letter#%">
On 2/20/06, Rick Faircloth <[EMAIL PROTECTED]> wrote: > What I'm after would be a list > of the company names that > match the letters in the form field > that start with the first letter of > the company name...not with the > form field letters just anywhere in the > name... > > E.g.... > > Search for the letter "A" would bring up > > Allstate > AIM > > Not: > > Hartford > Allstate > AIM > > or > > if the search was for "All"... > > Allstate > > would match... -- CFAJAX docs and other useful articles: http://jr-holmes.coldfusionjournal.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232885 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
