Conversion failed when converting the nvarchar value 'F02F741A0788' to data type int. code example

Example: Conversion failed when converting the varchar value to data type int.

CONVERT(INT,
        CASE
        WHEN IsNumeric(CONVERT(VARCHAR(12), a.value)) = 1 THEN CONVERT(VARCHAR(12),a.value)
        ELSE 0 END)