format a numeric values with commas

hi,
I have requirement.
I want to format a numeric value with commas. is there
any function to use in transact-sql query to do this.
for example if the numeric value is 27519.37 then it
should be formatted as 27,519.37
if the numeric value is 1221512.34 then it should be
formatted as 1,221,512.34
regards,
hari.
declare @.list_price numeric(20,6)
set @.list_price = 1221512.34
select
convert(varchar(100),cast(@.list_price as money),1)
Steve Kass
Drew University
hari wrote:

>hi,
> I have requirement.
> I want to format a numeric value with commas. is there
>any function to use in transact-sql query to do this.
>for example if the numeric value is 27519.37 then it
>should be formatted as 27,519.37
> if the numeric value is 1221512.34 then it should be
>formatted as 1,221,512.34
>regards,
>hari.
>
>
|||hi Steve,
Thanks for that. it is working fine.
But for the whole numbers like 123456 it is not doing so.
it is formatting to 1,234,567.00 (with two zeroes after
decimal). i want it to be formatted as 1,234,567
how to format 1234567 to 1,234,567.
thanks,
hari.

>--Original Message--
>declare @.list_price numeric(20,6)
>set @.list_price = 1221512.34
>select
> convert(varchar(100),cast(@.list_price as money),1)
>Steve Kass
>Drew University
>hari wrote:
>.
>
|||Dear Friend
Do you have the VBA Code which convert a numeric values to spelling in MS Access/Visual Basic
For exmple
"1234" converts to "one thousand two hundred thirty four Only"