Re: Output !

Thanks dear !

"Sue Hoegemeier" <Sue_H@xxxxxxxxxxxxx> wrote in message
news:nagat119buf4sdbmbfnq3o035ag2am0g19@xxxxxxxxxx
> Formatting is typically better off done on the client side.
> Otherwise, you need to convert or cast the value to money to
> get what you are after. Something like:
> DECLARE @YourValue integer
> SET @YourValue = 145263
> SELECT reverse(substring(reverse(convert(varchar, cast
> (@YourValue as money), 1)),
> 4, 30))
>
> -Sue
>
> On Mon, 23 Jan 2006 14:00:54 -0500, "Rogers"
> <naissani@xxxxxxxxxxx> wrote:
>
>>
>>I have a colunms which contain all the numeric data I want to change the
>>format in the runtime like
>>
>>145263 that should be like 145,263.
>>
>>Is there any way to do through sql query?
>>
>>Thanks
>>
>


.

Relevant Pages

  • Re: Output !
    ... Formatting is typically better off done on the client side. ... you need to convert or cast the value to money to ... DECLARE @YourValue integer ...
    (microsoft.public.sqlserver.clients)
  • Re: regarding unix specific commands
    ... know about to a variadic function is to cast it. ... The type must have a size less than or equal to the cast type ... C99 has solved these problems by defining a formatting modifier for each ... for my own printf implementation I introduced a formatting ...
    (comp.unix.programmer)
  • Re: prePEP: Money data type
    ... You're right, Alex, in that arithmetic is the real issue to be addressed, ... I also wonder if computation error should be tracked with this class, ... when you assign a Money type value of 1.21 then you know that the error is ... > amounts of attention on formatting. ...
    (comp.lang.python)
  • Re: Commentary on "Atlas Shrugged"
    ... about letting the best succeed but that you have to start with money ... "Do not give dogs what is holy; neither cast your pearls before ... Are you casting foul asparagus ... it has been beaten to death. ...
    (sci.military.naval)
  • GL -- Guiding Light Needs To Cut Down The Cast
    ... they used her correctly that would save money. ... maybe provide the cast with breakfast twice a week instead. ... but I'm upset about all the soaps right now. ... we had some clunkers with the Inside the Lights but we also had some ...
    (rec.arts.tv.soaps.cbs)
Loading