Help With SQL Expressin Field - ISNULL for Oracle 1

[TomSalvato]

Hi All,

I know that 'isnull' is not supported by Oracle ... I have the following SQL expression field that is working fine ...

(
SELECT COUNT("TABLE"."OBJECTID")
FROM "DB"."TABLE"
WHERE "TABLE"."RELATEDOID" = "MYTABLE"."OBJECTID"
)

this works, but I need to add another filter ... I need to add the Oracle equivilant of the following ...

AND not isnull("TABLE"."ACTIONDATE")

Thanx for any help!

-TS

 

[briangriffin]

Deceptively simple...

where table.actiondate is not null

 

[TomSalvato]

Thanx so much, Brian ... interestingly enough, I just figured that out by a little trial and error. You're right, it's so simple that I just overlooked the obvious.

Thanx again!

-TS