SELECT CASE
WHEN
        "%IM033A%" IS NULL
THEN
        " "
WHEN
        "%IM003A%"= " "
THEN
        " "
WHEN
        CHARINDEX("Anti-HIV POSITIVE", "%IM033A%") = 1
THEN
        "Anti-HIV POSITIVE"
WHEN
        CHARINDEX("Negative", "%IM033A%") = 1
THEN
        "Negative"
ELSE
        " inconclusive"
END

Embed on website

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