Stock Quantity With Decimals
I have noted that we've got some stock items whose Quantity include Decimals yet they are suppossed to be whole numbers.
For instance: for Bread: OITM.OnHand=10.5
I want to come up with a query to display all these kind of items. Whats the right Condition in an SQL query to achieve this? Thanks
Try this query:
Select itemcode, itemname from OITM where Onhand > Round(Onhand,0)