Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

decimal places in Query generator

Hi All,

I am observing a weird behavior in Query generator's execution of a simple sql query. the query is :

Select 0.002834

now, in the general settings - display - amounts , I put the decimal value as 4 or 6, then only it prints 0.0028 or 0.002834.

else it prints 0.00 (if the decimal place is 2). it should ideally have nothing to do with the display of amount. any idea?

(the effect is shown only after you change the decimal display, update it and close and reopen the SAP application.

Thanks,

Binita

Edited by: Binita Joshi on Apr 12, 2010 4:03 PM

Former Member
Former Member replied

Dear Binita,

You can try converting your sql result to char like this:

Select CAST(0.002834 AS CHAR)

Regards,

Nghia

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question