These quirky functions keep us TSQL developers special. The ISNUMERIC tests a field, and CAST converts it if you want.

CASE ISNUMERIC(LEFT(a.[CHBID], 7))

WHEN 1

THEN CAST(LEFT(a.[CHBID], 7) AS INT)

ELSE 0

END AS CHBID