Would that be ... WHERE CompanyName LIKE '#form.CompanyName#%'
-- Josh ----- Original Message ----- From: "Rick Faircloth" <[EMAIL PROTECTED]> To: "CF-Talk" <cf-talk@houseoffusion.com> Sent: Sunday, February 19, 2006 6:43 PM Subject: How would I write this query... > 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... > > ??? > > Rick > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232887 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