question about number format

I want to format the following numbers

189800 to $190K
2501000 to $2,501K

I used the following query (not sure what other way I can do)
but the problem is I don't know how to add comma.
is there an easier way to format the numbers in query?


SELECT '$'+ CONVERT(VARCHAR,CAST(ROUND(CONVERT(VARCHAR, 2501000/1000),0) AS
INT)) + 'K'


Thanks

Hello, Kevin

Try something like this:

CREATE TABLE #T (N INT)
INSERT INTO #T VALUES (189800)
INSERT INTO #T VALUES (2501000)

SELECT N, '$'+ REPLACE(CONVERT(varchar(10),
CONVERT(money,ROUND(N/1000.,0)),1),'.00','') + 'K'
FROM #T

DROP TABLE #T

--
Razvan Socol
SQL Server MVP