WHERE col LIKE '%abc%' will return any record where col contains abc. % = wildcard character. can come before, after, or both.
On 8/25/06, Jenny Gavin-Wear <[EMAIL PROTECTED]> wrote: > Is there something that works like CONTAINS that doesn't need full text > search enabled, please? > > Thanks, > Jenny > > > > -- > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.1.405 / Virus Database: 268.11.6/428 - Release Date: 25/08/2006 > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251112 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
