3 Replies Latest reply on Jan 28, 2018 7:10 PM by Zhouyi Zhang

    ISNULL shows as a value other than NULL

    Brian Fornelius

      Hi there,,,

       

      I am Joining a Excel file to a MYSql database and am wondering something.

       

      the excel file list a group of Hotel propeties that are preferred which I have set up as a column in the excel file.   However if I try to create a report to show all other properties (not the ones from the Excel file) I use ISNULL but the column shows NULL. instead of Preferred.  Is there a way to have them show as Non-Preferred' in the column?

       

      Kind of like in SQL when you would say and c.hotelname AS 'Hotel' 

       

      Thanks.