SELECT
    CASE When Status = 1 Then 'Active'
    ELSE 'Inactive'
    END As STATUSNAME
FROM M_USER