Try SELECT Movie, LPrice, Cost (FORMAT((100 * (LPrice * Cost) / Cost), '[>]990.0') + '%' ) FROM Movies
-- Dennis McGrath mailto:[EMAIL PROTECTED] -- Tools for R:BASE programmers http://www.enteract.com/~mcgrath/dennis -- Full time consultant with SQL Resources mailto:[EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of david blocker Sent: Sunday, October 28, 2001 5:45 PM To: [EMAIL PROTECTED] Subject: Problem with FORMAT function Dear R:Base Friends This expression in R:Base for DOS used to show ONE decimcal followed by a percent sign at the end of the result, as desired. It no longer does under R:Base for WIndows. Instead it shows TWO decimal places. Anyone know why? (It's not the SET MULTI setting: changing it has no effect) SELECT Movie, LPrice, Cost (FORMAT((100 * (LPrice * Cost) / Cost), '[>]990.0%')) FROM Movies David Blocker
