Re: Finding O'brien

First of all, like 'SOMESTRING' without a % is equivalent to = 'SOMESTRING'. You have to escape ' with a second ':

where X = 'O''Brien' will do the trick.

(Of course, if you insist on the like:
where X like 'O''Brien' does it as well)

hth
Rene

On 2005-03-15, mike <hillmw_at_charter.net> wrote:
> How does one go about trying to find O'Brien?
>
> the where clause would look like:
>
> "where sn like 'O'Brien'".
>
> Of course you get an error ....
>
> Mike
>

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch/