SELECT '(' + STUFF(STUFF( CAST(@phone AS varchar(16)), 4,0,')'), 8,0,'-') AS phonenumIt can be made into UDF.
-- Create scalar function (FN) IF EXISTS (SELECT * FROM sysobjects WHERE name = N'FormatPhone') DROP FUNCTION FormatPhone GO CREATE FUNCTION FormatPhone (@phone int) RETURNS varchar(16) AS BEGIN RETURN '(' + STUFF(STUFF( CAST(@phone AS varchar(16)), 4,0,')'), 8,0,'-') END GO SELECT dbo.FormatPhone(1112223333) GO