CASE Statement for BOMCAT_I in Dynamics GP Manufacturing BOM Revision Table BM010415

I have amassed a number of useful CASE statements, which can be incorporated into SQL queries run against Dynamics GP. When Querying the BOMCAT_I Field in Dynamics GP Manufacturing BOM Revision Table [BM010415].[BOMCAT_I] table: use the following case statement to return text versions of the BOM Categories in Dynamics GP:

select

CASE BM010415.BOMCAT_I

      WHEN 1 THEN 'MFG'

      WHEN 2 THEN 'ENG'

      WHEN 3 THEN 'ARCH'

      WHEN 4 THEN 'CONFIG'

      WHEN 5 THEN 'SUPER'

      ELSE 'ERROR'

END BOMCAT_I_TEXT,