CASE
WHEN
        "%IM054%" IS NULL
THEN
        " "
WHEN
        "%IM054%" = " "
THEN
        " "
WHEN
        "%IM054%" LIKE "%Positive%"
THEN
        "Alert!!"
WHEN
        "%IM054%" LIKE "%Negative%"
THEN
        " "
ELSE
        "Unknown Status"
END

Embed on website

To embed this project on your website, copy the following code and paste it into your website's HTML: