Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.

Dismiss

Formatting a number

0 views

Skip to first unread message

unread,

Aug 16, 2005, 5:07:43 AM8/16/05

Hi,

How do I change the format of a number in an sql query to return a
number in the format of #,### in Sybase?

I've tried format, cast... nothing seems to work..

Thanks !

Neta

unread,

Aug 16, 2005, 6:06:41 AM8/16/05

Use

substring (convert (char (N+3), convert (money, <NUMBER>, 1), 1, N)

in order to get an N-length string with commas for cardinal numbers.

<ne...@actimize.com> wrote in message
news:1124183263.1...@g44g2000cwa.googlegroups.com...

unread,

Aug 16, 2005, 12:04:00 PM8/16/05

Thanks !!!

0 new messages