format currency

[RK]

Hello All & Greetings.

Can someone pl tell me in a hurry how I can format a currency item in 2
decimal places.

thanks in advance.

RK

[Steve Kass]

Here are some choices. Formatting in SQL Server is limited,
since it is not intended to be a report generator.

declare @m money
set @m = 99999
select convert(varchar(30), @m, 1)
select convert(varchar(30), @m, 3)
select cast(@m as decimal(20,2))

Steve Kass
Drew University

RK wrote:

>Hello All & Greetings.
>
>Can someone pl tell me in a hurry how I can format a currency item in 2
>decimal places.
>
>thanks in advance.
>
>RK
>
>
>
>

[Andrew J. Kelly]

If your talking about displaying only 2 decimal places then take a look in
BooksOnLine under CONVERT and go about half way down to see a chart of 3
options for formatting currency.


--

Andrew J. Kelly
SQL Server MVP


"RK" <kishanb@cansciences.com> wrote in message
news:ei5Vju%23PDHA.3768@tk2msftngp13.phx.gbl...

> Hello All & Greetings.
>
> Can someone pl tell me in a hurry how I can format a currency item in 2
> decimal places.
>
> thanks in advance.
>
> RK
>
>

[nrutter]

I was using a number stepper for currency and I am now switching the code to
just a textInput. I am using the below code but if I set it this way it
doesn't allow me to use a peroid to seperate my dollar amounts. Example if I
type 3.22 it comes out as 322 I need it to allow the decimal

<mx:TextInput id="TXTpostageTotal" text="{caseVO.postageTotal}"
change="caseVO.postageTotal = Number(TXTpostageTotal.text);doUpdate();"/>