help needed for displaying a numeric value in a aprticular format..URGENT!!

[sangram_149]

hi,
i have a query which fetches the sum of amounts from a table .the
column is 19 bytes
but the query returns only the actual amount..for example ..it returns
...
-1245.00

but i want it to return all the 19 digits including the zeros and the
sign on the left
-000000000001245.00

plz tell me how this can be odne..its urgent

[Raj]

do this ...

select digits(c1) from t1

Raj

[Gert van der Kooij]

In article <11**********************@j33g2000cwa.googlegroups .com>,
sp****@yahoo.com says...

do this ...

select digits(c1) from t1

the digits function will strip of the negative sign. It can be added
with a case statement, something like this:
select case when c1 < 0 then '-' else ' ' end concat digits(c1) from t1

[sangram_149]

thx dude.. but it removes the sign and the decimal point also ...is
there any other way this can be done...

[p175]

What are you going to do with the result is I guess the question. You
could export it as a dec(19,2) which works fine, or convert it to a
char as in SELECT CHAR(DEC(SUM(C1),19,2)) FROM T1 if it is only going
to be displayed. If it's gonna be used numerically then I don't have an
answer I'm afraid.

[--CELKO--]

>> but i want it to return all the 19 digits including the zeros and the sign on the left <<

What is the basic prinicple of a tiered architecture? Display is done
in the front end and not in the database. Someone was asleep in class
or really likes to use kludges.

[Tony Rogerson]

--CELKO-- wrote:

but i want it to return all the 19 digits including the zeros and the sign on the left <<

What is the basic prinicple of a tiered architecture? Display is done
in the front end and not in the database. Someone was asleep in class
or really likes to use kludges.

Wrong! Display is done where it is most efficient to do it, you need to
consider other scalability parameters - network bandwidth, client spec
etc...

See
http://sqlblogcasts.com/blogs/tonyro...05/11/429.aspx
for a my opinion on this.

Who was asleep in the class on 'developing for a scalable
architecture', that was the class that had practical excercises rather
than just theory!