Number appearance

[Mikkel Olsen]

When i make a qeury with some data of the type numeric, how do i make the output come with digit grouping symbol. Like 1.000.000,00.

Now the output looks like 1000000,00.

[Jonathan Yang]

Mikkel,

I think you mean 1000000.00==> 1,000,000.00

use the combination of

COVERT(CHAR(10),$field)
SUBSTRING(string, n1, n2)
LTRIN(string)
and operator `+`


Good luck

On 7/30/98 3:36:54 AM, Mikkel Olsen wrote:
> When i make a qeury with some data of the type numeric, how do i make the
> output come with digit grouping symbol. Like 1.000.000,00.

Now the
> output looks like 1000000,00.

[Don Romano]

On 7/30/98 7:01:07 PM, Jonathan Yang wrote:
> Mikkel,

I think you mean 1000000.00==> 1,000,000.00

Unless his country doesn`t format numbers that way. Some countries use the comma `,` for the decimal point and the decimal for the grouping.

Try:

select convert(money,yournumericvariable)

(Hopefully that works internationally as well as here in the US)

Good luck

On 7/30/98 3:36:54
> AM, Mikkel Olsen wrote:
> When i make a qeury with some data of the type
> numeric, how do i make the
> output come with digit grouping symbol. Like
> 1.000.000,00.

Now the
> output looks like 1000000,00.