ASP and inserting commas

[sila]

Hello

I need to be able to insert commas such as this 1,000,000 (i.e. into one or two places depending on length) into figures selected from a SQL sertver db with asp. Is there a function that will do this or would it be custom code? If so how do i do it?

Thanks

 

[Veep]

FormatNumber(Expression [,NumDigitsAfterDecimal [,IncludeLeadingDigit [,UseParensForNegativeNumbers [,GroupDigits]]]])

 

[onpnt]

will FormatNumber() work for ya?

___________________________________________________________________
[sub]

http://www.onpnt.com

The answer to your ??'s may be closer then you think. faq333-3811
Join the Northern Illinois/Southern Wisconsin members in Forum1064[/sub]

 

[onpnt]

Someone used to pick on me for remembering the syntax to built in functions like that

___________________________________________________________________
[sub]

http://www.onpnt.com

The answer to your ??'s may be closer then you think. faq333-3811
Join the Northern Illinois/Southern Wisconsin members in Forum1064[/sub]

 

[Tarwn]

No idea who that was

[sub]01000111 01101111 01110100 00100000 01000011 01101111 01100110 01100110 01100101 01100101 00111111[/sub]
The never-completed website:

http://www.tiernok.com/