Searching on Text string that contains single quotes

[ulicki]

Hi,

I cannot run the following query in Query Analyzer, I get an error:

SELECT NAME_LAST, OPT_ID,OPT_NUM FROM OPTIONEE WHERE OPT_ID = '999999999'AND UPPER(NAME_LAST) = 'O'BRIEN';

My problem is that the name O'BRIEN contains a single quote. How can I work around this?

Using SQL Server 2000.

Thanks

 

[vongrunt]

Use two quotes instead ('O''BRIEN').

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[ulicki]

Hi,
Thanks for the reply,

It worked!!!