,''))
WHEN 0 THEN CAST('' AS CHAR(30))
ELSE
CASE WHEN PATINDEX('%[1-9]%', [A].[Code]) = 0 THEN CAST('' AS CHAR(30))
ELSE
CAST
(
CAST
(
REPLACE
(
CASE WHEN PATINDEX('[0-9]', SUBSTRING([A].[Code],1,1)) = 1 THEN SUBSTRING([A].[Code],1,1) ELSE '' END
+ CASE WHEN PATINDEX('[0-9]', SUBSTRING([A].[Code],2,1)) = 1 THEN SUBSTRING([A].[Code],2,1) ELSE '' END
+ CASE WHEN PATINDEX('[0-9]', SUBSTRING([A].[Code],3,1)) = 1 THEN SUBSTRING([A].[Code],3,1) ELSE '' END
+ CASE WHEN PATINDEX('[0-9]', SUBSTRING([A].[Code],4,1)) = 1 THEN SUBSTRING([A].[Code],4,1) ELSE '' END
+ CASE WHEN PATINDEX('[0-9]', SUBSTRING([A].[Code],5,1)) = 1 THEN SUBSTRING([A].[Code],5,1) ELSE '' END
+ CASE WHEN PATINDEX('[0-9]', SUBSTRING([A].[Code],6,1)) = 1 THEN SUBSTRING([A].[Code],6,1) ELSE '' END
+ CASE WHEN PATINDEX('[0-9]', SUBSTRING([A].[Code],7,1)) = 1 THEN SUBSTRING([A].[Code],7,1) ELSE '' END
+ CASE WHEN PATINDEX('[0-9]', SUBSTRING([A].[Code],8,1)) = 1 THEN SUBSTRING([A].[Code],8,1) ELSE '' END
+ CASE WHEN PATINDEX('[0-9]', SUBSTRING([A].[Code],9,1)) = 1 THEN SUBSTRING([A].[Code],9,1) ELSE '' END
+ CASE WHEN PATINDEX('[0-9]', SUBSTRING([A].[Code],10,1)) = 1 THEN SUBSTRING([A].[Code],10,1) ELSE '' END
,' ',''
) AS NUMERIC(28,0))
AS CHAR(30))
END
END --- Adjust this code to you field size
and then group by this new field and calculate SUM(ATM)