>Is there a TRANSFORM() like function in SQL server?
>
>For example, can you do something like this in SQL Server?
>
>TRANSFORM(phone,"@R (999) 999-9999")


Hi Bob,

No such luck. You'll have to use multiple T-SQL functions to get result.

SELECT 
	'(' + STUFF(STUFF( CAST(@phone AS varchar(16)), 4,0,')'), 8,0,'-') AS phonenum

It 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