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?

SQL Server is about storing data - the formatting for display should be done in your front-end application (web app or whatever). SQL Server / T-SQL doesn't have any extensive formatting capabilities. — marc_s
– marc_s, Commented Nov 13, 2011 at 15:05
Whilst it is absolutely the case that one should do conversion formatting as late as possible - as close to the "user" as possible - it is also the case that there may well be a good reason to need to do so in a query in this case - therefore the comment as written (i.e. without asking for clarification/justification) is not really a positive contribution and certainly NOT a great comment. — Murph
– Murph, Commented Nov 13, 2011 at 15:19

Royi Namir · Accepted Answer · 2011-11-13 15:05:19Z

4

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

answered Nov 13, 2011 at 15:05

Royi Namir

149k145 gold badges502 silver badges833 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1