Re: Single Quote ( ' ) problem in SQL

Single quotes can be mimicked in SQLPLUS statements by including two consecutive quotes ... hence

        Select blah, blah, blah 
        From A
        where Name = 'O'Conner';
 

should become ...

        where Name = 'O''Conner';

(that's two single quotes, not one double! Received on Mon Mar 10 1997 - 00:00:00 CST