sql server mseq: format a numeric values with commas -- sql server mseq

Re: format a numeric values with commas

Steve Kass
9/22/2004 9:54:01 AM

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

[quoted text, click to view]

Re: format a numeric values with commas

hari
9/23/2004 12:59:51 AM

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.

[quoted text, click to view]

Re: format a numeric values with commas

pranab_das26
11/10/2004 1:23:42 AM

Dear Friend

Do you have the VBA Code which convert a numeric values to spelling i
MS Access/Visual Basic

For exmple

"1234" converts to "one thousand two hundred thirty four Only

-
pranab_das2
-----------------------------------------------------------------------
Posted via http://www.mcse.m
-----------------------------------------------------------------------
View this thread: http://www.mcse.ms/message1084920.htm

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server mseq group.