How to Check if a BNF Code is Generic
SELECT [IsGeneric] = (CASE WHEN [BNFCode] LIKE '_________AA____' THEN 1 ELSE 0 END)
,[GenericMask] = CONCAT(LEFT([BNFCode], 9), 'AA', RIGHT([B].[Code],2), '__')
SELECT [IsGeneric] = (CASE WHEN [BNFCode] LIKE '_________AA____' THEN 1 ELSE 0 END)
,[GenericMask] = CONCAT(LEFT([BNFCode], 9), 'AA', RIGHT([B].[Code],2), '__')