ISNULL Problems

[Schnappa]

Hi

Progressing my coding from Crystal Reports into SQL, and running into some problems with NULL and ISNULL calculations. The following is some basic coding I have done, and am getting errors around the ISNULL statement.

I would be gratfeul for any help.

Thanks

GV

SELECT
"OtherAsset"."id",
"PartyFinancialItem"."partyId",
"OtherAsset"."type",
CASE "OtherAsset"."type"
WHEN 'Deposit' THEN "OtherAsset"."accounttype"
WHEN 'Other' THEN
CASE "OtherAsset"."otherdescription"
WHEN ISNULL THEN "OtherAsset"."othertype"
ELSE "OtherAsset"."otherdescription"
END
END,
"OtherAsset"."xvalue"

FROM "Phase2FiordlandApp"."dbo"."OtherAsset" "OtherAsset"
LEFT OUTER JOIN "Phase2FiordlandApp"."dbo"."PartyFinancialItem" "PartyFinancialItem"
ON "OtherAsset"."id"="PartyFinancialItem"."financialItemId

 

[GISql]

Instead of: CASE "OtherAsset"."otherdescription"
WHEN ISNULL THEN "OtherAsset"."othertype"
ELSE "OtherAsset"."otherdescription"
END

Why not use:
ISNULL("OtherAsset"."otherdescription", "OtherAsset"."othertype")

 

[Schnappa]

Thanks for that GISql...Works a treat.

Cheers

GV