Select CASE WHEN ItemUOM.BalQty>0 THEN 'RED' ELSE 'BLUE' END
Expected result must put RED (Capital Letter)