SELECT * FROM XYZ WHERE ColumnName like 'A%'
-----Original Message----- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Sunday, February 19, 2006 9:43 PM To: CF-Talk 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:232886 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