Enum categories and values

SELECT
imsmaenum.enumcategory
FROM
imsmaenum
WHERE
imsmaenum.enumcategory NOT LIKE  'cbo%'
GROUP BY
imsmaenum.enumcategory

-------------------------------------------------------------------------------
SELECT
imsmaenum.enumcategory,
imsmaenum.enumvalue
FROM
imsmaenum
WHERE
imsmaenum.enumcategory NOT LIKE  'cbo%'