How Can I Format Strings With T-Sql

Question

I want use 1000 separator(,) for numeric values.

how can i format strings with T-Sql Functions?

Answer 1

select convert(varchar(10), cast(1234.333 as money), 1)