SELECT
        CASE
        WHEN
                "%IM054%" IS NULL
        THEN
                " "
        WHEN
                "%IM054%" = " "
        THEN
                " "
        WHEN
                CHARINDEX("REACTIVE", "%IM054%") = 1
        THEN
                "Alert!!"
        WHEN
                CHARINDEX("Non", "%IM054%") = 1
        THEN
                " "
        ELSE
                "Unknown Status"
        END