From: jbfidelia@multicorpora.ca   
      
   Hi there,   
      
   I have a table in an Oracle 9i R2 database containing the following string"   
      
     "It's so easy"   
      
   When I try to execute the following query:   
     SELECT EXPRESSION FROM EXPRESSIONS WHERE EXPRESSION = "It's so easy"   
      
   I recieve an error:   
   ORA-01740-Missing double quote in identifier   
      
   I tried to correct the query with a double quote:   
     SELECT EXPRESSION FROM EXPRESSIONS WHERE EXPRESSION = "It''s so easy"   
      
   then the query return empty.   
      
   Is there something I'm doing wrong ?   
      
   The definition of the table is   
      
   CREATE TABLE EXPRESSIONS   
   (   
       ID                              NUMBER(8)              NOT NULL,   
       EXPRESSION_IDXED NVARCHAR2(500)     NULL,   
       CREATEDATE            DATE                       NULL,   
       CREATEBY                NVARCHAR2(20)      NULL,   
   )   
      
   Thanks for your help.   
      
   JBF   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)