>From http://www.postgresql.org/docs/8.0/static/functions-matching.html
"The key word ILIKE can be used instead of LIKE to make the match case-insensitive according to the active locale. This is not in the SQL standard but is a PostgreSQL extension." Joe Kelly On 5/13/05, Mark Armstrong <[EMAIL PROTECTED]> wrote: > PostgreSQL on Apache 2 - I didn't have this issue on the old SQL 7 on > NT DB. I'll check the settings! > > Thank you! > > Mark > > > On May 13, 2005, at 12:07 PM, Daniel Elmore wrote: > > > Your database must be set to a case sensitive collation. What's your > > DB? > > > > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > Behalf Of Mark Armstrong > > Sent: Friday, May 13, 2005 12:01 PM > > To: [email protected] > > Subject: CF newbie: Search Non Case Sensitive Results > > > > > > Its seems by default searching records is case sensitive, how do I tell > > the search to ignore case? > > > > my search code: > > > > > > <cfquery datasource="datasource" name="getMembers"> > > SELECT * > > FROM members > > <cfif isDefined("search")> > > Where Lastname like '%#search#%' > > or firstname like '%#search#%' > > or homeAddress like '%#search#%' > > or workAddress like '%#search#%' > > or homeCity like '%#search#%' > > or workCity like '%#search#%' > > or homeState like '%#search#%' > > or workState like '%#search#%' > > or workZip like '%#search#%' > > or workphone like '%#search#%' > > or homephone like '%#search#%' > > or email like '%#search#%' > > or homeZip like '%#search#%' > > </cfif> > > Order By Lastname ASC > > </cfquery> > > > > > > thanks for any suggestions! > > > > mark > > > > ---------------------------------------------------------- > > To post, send email to [email protected] > > To unsubscribe: > > http://www.dfwcfug.org/form_MemberUnsubscribe.cfm > > To subscribe: > > http://www.dfwcfug.org/form_MemberRegistration.cfm > > > > > > > > > > > > ---------------------------------------------------------- > > To post, send email to [email protected] > > To unsubscribe: > > http://www.dfwcfug.org/form_MemberUnsubscribe.cfm > > To subscribe: > > http://www.dfwcfug.org/form_MemberRegistration.cfm > > > > > > ---------------------------------------------------------- > To post, send email to [email protected] > To unsubscribe: > http://www.dfwcfug.org/form_MemberUnsubscribe.cfm > To subscribe: > http://www.dfwcfug.org/form_MemberRegistration.cfm > > -- Thanks, Joe Kelly ---------------------------------------------------------- To post, send email to [email protected] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
