What is the most feasible way to emulate the below MySQL function into postgreSQL. Since the isnull() function is no longer supported in 9.6 version. I have tried every trick in the hat to get the desired results. Still 'RPG INV' doesn't show only the other two then options show up. (case when ((`s`.`Funding_Date` = '') and (isnull(`s`.`Actual_Close_Date`) or (`s`.`Actual_Close_Date` = ''))) then 'RPG_INV' when ((isnull(`s`.`Funding_Date`) or (`s`.`Funding_Date` <> '')) and ((`s`.`Actual_Close_Date` = '') or isnull(`s`.`Actual_Close_Date`))) then 'Builder_Inventory' else 'Owner_Inventory' end) AS `Lot_Status` -- View this message in context: http://postgresql.nabble.com/isnull-function-in-pgAdmin3-tp5923122p5924161.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general