Michael Maddison
michael at ddisolutions.com.au
Wed Jun 9 06:48:02 CDT 2010
Ugly, yes. It will be war on hyphens next. I guess this will work. WHERE Surname like '%' + @search + '%' OR --The can spell way replace( Surname,'''','') like '%' + replace(@search,' ','') + '%' Michael M The obvious would be to do a replace on ' and space and then compare against names pre-stripped. Ugly in any case. John W. Colby www.ColbyConsulting.com Michael Maddison wrote: > Hi Guys, > > > > It's late at night and I really don't know how to respond to this > request... > > > > "Currently for a name such as O'Tool you have to enter in the ' to get > the name to come up, is it possible to get the search to recognise a > name such as this when options such as O Tool or Otool are put in by the > user" > > > > My 1st reaction was to laugh, should I be crying? > > I think I'd have to do a replace on the field side of the where > clause... I'd have to do a replace for each scenario I think. > > > > Ideas? > > > > Cheers > > > > Michael M > > _______________________________________________ > dba-VB mailing list > dba-VB at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-vb > http://www.databaseadvisors.com > > _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.829 / Virus Database: 271.1.1/2926 - Release Date: 06/09/10 04:35:00