[Top] [All Lists]

Like operator in a query

Subject: Like operator in a query
From: "ssailer"
Date: Wed, 15 Aug 2007 22:21:36 +0000 UTC
Newsgroups: macromedia.coldfusion.cfml_general_discussion
I need a user to be able to enter a city to pull up results for that city using 
a LIKE operator.  However, if the master list contains St. Paul, instead of 
Saint Paul, how can I get either one to show up?  I've tried several things and 
I just can't get it to work!!!  Thanks!

<Prev in Thread] Current Thread [Next in Thread>