hi

i am retriving value from sql server database like

select cast(round(12345674.8658,2,0) as decimal(20,2))

output is 12345674.87
but i want to get like 12,345,674.87
any function is there?

You can format the display by using the FormatNumber function. Its format is:

FormatNumber(value, numdigits, leadingzero, negparen, delimiter)
The 2nd, 3rd, 4th, and 5th options are tristate (-2=system default, -1=on, 0=off).

So you probably want something like this:
Response.write(FormatNumber(value, 2, 0, 0, -1))
value must be numerical data

If you want the dollar sign use FormatCurrency. Its properties are the same, except it displays the dollar sign.