SELECT /* +firstrows */ BIB_TEXT.BIB_ID, TITLE_BRIEF AS TITLE,
(CASE
  WHEN SUBSTR(TITLE_BRIEF,1,1)  BETWEEN 'A' AND 'Z' THEN SUBSTR(TITLE_BRIEF,1,1)
  WHEN SUBSTR(TITLE_BRIEF,1,1)  BETWEEN '0' AND '9' THEN 'Numbers'
  ELSE 'Other'
END)
AS CATEGORY 
FROM (((BIB_TEXT INNER JOIN BIB_ITEM ON BIB_TEXT.BIB_ID = BIB_ITEM.BIB_ID) INNER JOIN ITEM ON BIB_ITEM.ITEM_ID = ITEM.ITEM_ID) INNER JOIN ITEM_TYPE ON ITEM.ITEM_TYPE_ID = ITEM_TYPE.ITEM_TYPE_ID) INNER JOIN BIB_MASTER ON BIB_TEXT.BIB_ID = BIB_MASTER.BIB_ID
WHERE (((ITEM_TYPE.ITEM_TYPE_NAME)='DVD') AND ((BIB_MASTER.SUPPRESS_IN_OPAC)<>'Y'))