String fromat like this from Oracle DB to_char ("100000",'#####09.99S')

[#1]

is there away to format Text oder number in QV like this to_char ("100000",'#####09.99S')

This spezial Format ist from a ORACLE DB Server.

Any ideas?

thx.

Renato

[#2]

The output looks like this 100000+

thx

[#3]

me again,

The output looks like this 100000+

thx

[hector]

Hi, can you put the result for that input value?

to_char ("100000",'#####09.99S') = ??????

or explain us what means the #, 9's and the "S"

rgds

[hector · Accepted solution]

I'm sorry that is the result?

100000+ ??? with the '+' sign? which means it's a positive number??

maybe you can try, something like this

dual(text(num(100000,'#.##0,00')) & if(100000>0,'+','-'), 100000) //I have . as 1000 sep and , as decimal sep

dual(text(num(100000,'#,##0.00')) & if(100000>0,'+','-'), 100000) //Inverting the separators

So the value will be 100.000,00+, but internally will be 100000

Rgds