(Msg. 1) Posted: 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"
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
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office