Removing decimal points when printing

Ken wrote: >Hello All, >I'm still new to Informix, so if this one's a nobrainer (sorry)... >I have a field defined like: real_estate Interger >It could contain a value such as: 1500.47 >Question is, > when printing a report I want to display the number as 150047 >No decimal point. >Is there a somewhat simple way to do this ? >Thanks in advance for any ideas, >--------------- >Ken Mccoy >Applications Prog. Ignoring the fact that you say you are holding a fraction/decimal in an INTEGER field, you have neglected to say whether you are writing an ACE report or 4GL. Assuming it is 4GL you are interested in, try: PRINT xyz USING "#####" I cannot find the manual, so I am not entirely certain, but you should find a section that gives examples of the various print formats in Volume 1 of the Informix programmers reference. Mark Denham BBC London, UK Mark.Denham@bbc.co.uk