Perfect...thanks, Charlie... Rick
> -----Original Message----- > From: Charlie Griefer [mailto:[EMAIL PROTECTED] > Sent: Sunday, February 19, 2006 9:52 PM > To: CF-Talk > Subject: Re: How would I write this query... > > > WHERE > companyName LIKE '#form.companyName#%' > > the LIKE is similar to 'contains'. the % is a wildcard character, so > putting it at the end of the string means any string that starts with > #form.companyName#. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232889 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
