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
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