From: jbfidelia@multicorpora.ca   
      
   Hi again,   
      
   It was my mistake. I did the query without the uppercase on the first   
   letter. I corrected it and it works fine.   
   please disregard the previous post.   
      
   JBF.   
      
      
   "news"  wrote in message   
   news:SGl7b.36039$yg2.665188@weber.videotron.net...   
   > 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)