Group:  Microsoft Excel ยป microsoft.public.excel.querydao
Thread: Using IF statement in ODBC Microsoft query

Geek News

Using IF statement in ODBC Microsoft query
Kumar 6/3/2007 6:01:00 PM
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

Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net