Hi guys, another simple question. I'm pulling data from a table and there are two fields I'm interested in. One contains a value, and the other contains an override value. What I am trying to do is to check the override value for Null, if it is empty, use the default value, if it has a value us it.
In SQL Server, it would just be:
SELECT (field list...), CASE WHEN OVERRIDE_VALUE IS NULL THEN DEFAULT_VALUE ELSE OVERRIDE_VALUE END FieldAlias FROM (Table list...)