Help!

Using IF statement in ODBC Microsoft query

  
  
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Query DAO RSS
Next:  Connect Excel 2007 to SQL Reporting Services mode..  
Author Message
Kumar
External


Since: Jun 12, 2006
Posts: 6
PostPosted: Sun Jun 03, 2007 11:01 am    Post subject: Using IF statement in ODBC Microsoft query
Archived from groups: microsoft>public>excel>querydao (more info?)
Hi:

I am rying to extract data from Orcale into excel using ODBC,
since there are two date fields in a table I am trying to create a single
calculated field using an iF statement :
IF(PROMISE_DATE IS NULL,DESIRED_DATE,PROMISE_DATE)
but keep getting an error message "ORA-00907: missing right parenthisis"

appreciate any help
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Query DAO All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum