Re: Removing decimal points when printing

Posted in 1995

Richard Thomas — 17 Jul 1995 12:08:03 -0400 — source: Informix-list mailing list archive (1991-1998)

----- Begin Included Message ----- From ilist@rmy.emory.edu Fri Jul 14 18:29:08 1995 From: "Ken McCoy" <KENM@apscn.k12.ar.us> To: informix-list@rmy.emory.edu Date: Fri, 14 Jul 1995 10:57:56 CST Subject: Removing decimal points when printing X-Informix-List-To: rt10hp@csl.gov.uk X-Informix-List-Id: <list.6912> 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. ----- End Included Message ----- Ken, You could try defining a variable, "x", and then let x = real_estate * 100 Cheers, Richard ----------------------------------------------------------------- | _ /\\ | Richard Thomas | | \\ 0_ | r.thomas@csl.gov.uk | | \\ / | | | oo/ | "20 Regal and a four-pack, | | / \\ | I guess I'm set for the night" | | \\_/ | - "TV Tan" The Wildhearts | -----------------------------------------------------------------