In Foxpro 2.6 I displayed the contents of a quantity field conditionally using a calculated field in a browse window and IIF statements. The field is set to display 2 decimal places - 6,2. If the field contains a whole number it should be displayed as an integer. If it is 1.5 it should display like that and not 1.50 and if it is zero there should be nothing displayed. How do I achieve this with SQL statements that populate a list box.