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
>
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)
