My case statement below formats well, however, I'd like to convert the varchar output into a bigint, but I'm not sure where I'm going wrong. I receive the error message: Error converting data type varchar to bigint.
SET @StorePhone = '(123)456-7891'
StorePhone = CASE SUBSTRING(@StorePhone, 1,1) WHEN '('
ELSE 222222222 END