How to Check if a BNF Code is Generic

2nd February 2018 1 minute or less

SELECT [IsGeneric] = (CASE WHEN [BNFCode] LIKE '_________AA____' THEN 1 ELSE 0 END)
	,[GenericMask] = CONCAT(LEFT([BNFCode], 9), 'AA', RIGHT([B].[Code],2), '__')

Next Newest Post

Next Oldest Post