jwcolby
jwcolby at colbyconsulting.com
Wed Jun 9 06:24:11 CDT 2010
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 > >