    CASE 
        WHEN field3 BETWEEN 0 AND 50 THEN '*'
        WHEN field3 BETWEEN 51 AND 100 THEN '**'
        ELSE '***'
    END AS field3_caption