CASE
    -- กรณี Creatinine < 10
    WHEN U_CREA < 10 AND U_ALB < 10 THEN 'Re-Collect'
    WHEN U_CREA < 10 AND U_ALB = 10 THEN 'Re-Collect'
    WHEN U_CREA < 10 AND U_ALB >= 30 THEN 'N/A'

    -- กรณี Creatinine = 10
    WHEN U_CREA = 10 AND U_ALB < 10 THEN 'Re-Collect'
    WHEN U_CREA = 10 AND U_ALB = 10 THEN 'Re-Collect'
    WHEN U_CREA = 10 AND U_ALB = 30 THEN 300
    WHEN U_CREA = 10 AND U_ALB = 80 THEN 800
    WHEN U_CREA = 10 AND U_ALB = 150 THEN 1500
    WHEN U_CREA = 10 AND U_ALB > 150 THEN '>300'

    -- กรณี Creatinine = 50
    WHEN U_CREA = 50 AND U_ALB < 10 THEN '<30'
    WHEN U_CREA = 50 AND U_ALB = 10 THEN 20
    WHEN U_CREA = 50 AND U_ALB = 30 THEN 60
    WHEN U_CREA = 50 AND U_ALB = 80 THEN 160
    WHEN U_CREA = 50 AND U_ALB = 150 THEN 300
    WHEN U_CREA = 50 AND U_ALB > 150 THEN '>300'

    -- กรณี Creatinine = 100
    WHEN U_CREA = 100 AND U_ALB < 10 THEN '<30'
    WHEN U_CREA = 100 AND U_ALB = 10 THEN 10
    WHEN U_CREA = 100 AND U_ALB = 30 THEN 30
    WHEN U_CREA = 100 AND U_ALB = 80 THEN 80
    WHEN U_CREA = 100 AND U_ALB = 150 THEN 150
    WHEN U_CREA = 100 AND U_ALB > 150 THEN '>300'

    -- กรณี Creatinine = 200
    WHEN U_CREA = 200 AND U_ALB < 10 THEN '<30'
    WHEN U_CREA = 200 AND U_ALB = 10 THEN 5
    WHEN U_CREA = 200 AND U_ALB = 30 THEN 15
    WHEN U_CREA = 200 AND U_ALB = 80 THEN 40
    WHEN U_CREA = 200 AND U_ALB = 150 THEN 75
    WHEN U_CREA = 200 AND U_ALB > 150 THEN '>300'

    -- กรณี Creatinine = 300
    WHEN U_CREA = 300 AND U_ALB < 10 THEN '<30'
    WHEN U_CREA = 300 AND U_ALB = 10 THEN 3
    WHEN U_CREA = 300 AND U_ALB = 30 THEN 10
    WHEN U_CREA = 300 AND U_ALB = 80 THEN 27
    WHEN U_CREA = 300 AND U_ALB = 150 THEN 50
    WHEN U_CREA = 300 AND U_ALB > 150 THEN '>300'

    -- กรณี Creatinine > 300
    WHEN U_CREA > 300 AND U_ALB < 10 THEN '<30'
    WHEN U_CREA > 300 AND U_ALB = 10 THEN '<30'
    WHEN U_CREA > 300 AND U_ALB = 30 THEN '<30'
    WHEN U_CREA > 300 AND U_ALB = 80 THEN '<30'
    WHEN U_CREA > 300 AND U_ALB = 150 THEN '<30'
    WHEN U_CREA > 300 AND U_ALB > 150 THEN 'N/A'

    ELSE NULL
END 

Embed on website

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