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 > > > ______________________________________________________________________ Why Share? Dedicated Win 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=coldfusionc 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
