the MSsql install is by default case insensitive. ----- Original Message ----- From: "John Wilker" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, March 15, 2002 12:16 PM Subject: RE: SQL case insensitive search ???
> My query returns either when searching (on my SQL box) for '%elp%' found > "Help Desk" and "HELP DESK" and '%ELP%' did likewise. > > But yeah Lcase() or Ucase() ing the string I would think would do it if > you aren't getting the same results. > > J. > > John Wilker > Web Applications Consultant, and Author > Macromedia Certified ColdFusion Developer > President/Founder, Inland Empire CFUG. > www.red-omega.com > > "more people are killed by donkeys than by airplane crashes each year" > > > -----Original Message----- > From: Brian Scandale [mailto:[EMAIL PROTECTED]] > Sent: Thursday, March 14, 2002 10:44 PM > To: CF-Talk > Subject: RE: SQL case insensitive search ??? > > > I guess I need to explain it better then. > > Yes the % is a wildcard in front of the search string.. and behind it > too in my example .... > > HOWEVER, the search string itself is NOT case insensitive... so it will > only find exactmatch of searchstring > > Example '%he%' finds 'the' but not 'THE' > > I would like to find regardless of case... > > How is that done? > > > At 09:38 PM 3/14/02 -0800, you wrote: > >it should be case insensitive to begin with? > > > >All '%searchString%' does is cause your query to table scan the whole > >table since the wildcard is in front. > > > >J. > > > >John Wilker > >Web Applications Consultant, and Author > >Macromedia Certified ColdFusion Developer > >President/Founder, Inland Empire CFUG. > >www.red-omega.com > > > >"more people are killed by donkeys than by airplane crashes each year" > > > > > >-----Original Message----- > >From: Brian Scandale [mailto:[EMAIL PROTECTED]] > >Sent: Thursday, March 14, 2002 9:36 PM > >To: CF-Talk > >Subject: SQL case insensitive search ??? > > > > > >how does one go about structuring a case insensitive search on a text > >field in a database? > > > >Currently using > > > >WHERE Table.FieldName LIKE '%searchString%' > > > >Thanks, > >Brian > > > > > > > > ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
