CASE
    -- Group O: Anti-A Neg, Anti-B Neg, Anti-AB Neg, A cell Pos, B cell Pos
    WHEN "%BB007A%" = "Negative" 
     AND "%BB007B%" = "Negative" 
     AND "%BB007C%" = "Negative"
     AND "%Acell%" LIKE "%Positive%"
     AND "%Bcell%" LIKE "%Positive%"
        THEN "O"

    -- Group A: Anti-A Pos, Anti-B Neg, Anti-AB Pos, A cell Neg, B cell Pos
    WHEN "%BB007A%" LIKE "%Positive%" 
     AND "%BB007B%" = "Negative" 
     AND "%BB007C%" LIKE "%Positive%"
     AND "%Acell%" = "Negative"
     AND "%Bcell%" LIKE "%Positive%"
        THEN "A"

    -- Group B: Anti-A Neg, Anti-B Pos, Anti-AB Pos, A cell Pos, B cell Neg
    WHEN "%BB007A%" = "Negative" 
     AND "%BB007B%" LIKE "%Positive%" 
     AND "%BB007C%" LIKE "%Positive%"
     AND "%Acell%" LIKE "%Positive%"
     AND "%Bcell%" = "Negative"
        THEN "B"

    -- Group AB: Anti-A Pos, Anti-B Pos, Anti-AB Pos, A cell Neg, B cell Neg
    WHEN "%BB007A%" LIKE "%Positive%" 
     AND "%BB007B%" LIKE "%Positive%" 
     AND "%BB007C%" LIKE "%Positive%"
     AND "%Acell%" = "Negative"
     AND "%Bcell%" = "Negative"
        THEN "AB"

    ELSE "Invalid"
END
*****







CASE
    WHEN "%BB007A%" = "Negative" 
     AND "%BB007B%" = "Negative" 
     AND "%BB007C%" = "Negative" 
        THEN "O"

    WHEN "%BB007A%" LIKE "%Positive%" 
     AND "%BB007B%" = "Negative" 
     AND "%BB007C%" LIKE "%Positive%" 
        THEN "A"

    WHEN "%BB007A%" = "Negative" 
     AND "%BB007B%" LIKE "%Positive%" 
     AND "%BB007C%" LIKE "%Positive%" 
        THEN "B"

    WHEN "%BB007A%" LIKE "%Positive%" 
     AND "%BB007B%" LIKE "%Positive%" 
     AND "%BB007C%" LIKE "%Positive%" 
        THEN "AB"

    ELSE "Invalid"
END


---
CASE
    WHEN "%BB007A%" = "Negative" AND "%BB007B%" = "Negative" THEN "O"
    WHEN "%BB007A%" LIKE "%Positive%" AND "%BB007B%" = "Negative" THEN "A"
    WHEN "%BB007A%" = "Negative" AND "%BB007B%" LIKE "%Positive%" THEN "B"
    WHEN "%BB007A%" LIKE "%Positive%" AND "%BB007B%" LIKE "%Positive%" THEN "AB"
    ELSE "Invalid"
END