SELECT T.sPhoneNum1 AS 'Phone Number - Raw/Unformatted',

'(' + Stuff(Stuff(T.sPhoneNum1,len(T.sPhoneNum1)-3,0,'-'),len(T.sPhoneNum1)-6,0,') ') AS 'Phone Number-Formatted'

FROM (SELECT '9991112222' AS 'sPhoneNum1') T

Will work for phone number with...