Skip to Content

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

SELECTING DEC 8 2. value from DB ? ( Decimal places contains some value )

There is a table in which one field is of type DEC 8 2.

I have to select all records for which this field can have decimal places( I mean decimal places have some value instead of '00' ).

How to write my SELECT stmt ?

For eg 12.00 , 657.00, 123.12...

I need to SELECT only 123.12 value .

Could you please suggest me how can I SELECT those values in my SELECT stmt ?



Helpful Answer

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