I am trying to get my database to show a zero when its NULL (I know in formulas you can use the IF NULL(“ColumnName”, ‘0’ but this does not work in a stand alone select statement without a formula). I was told I should try a CASE WHEN but I could not get it to work. I tried
CASE (“ColumnName”) IS NULL THEN ‘0’ ELSE “ColumnName”
And I got SQL error so I am obviously missing something - or can I not use CASE WHEN in LO Base?
I am running LO Base 188.8.131.52 on Ubuntu 13.4