I needed string.Format in SQL just now, so I made it up (not very exciting but nicer than writing nested REPLACE statements. YMMV
DROP FUNCTION dbo.fnFormatString
GO
CREATE FUNCTION dbo.fnFormatString(@format varchar(6000),
@arg1 sql_variant,
Read More