[dba-VB] Client question!

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