Jan FYI I was fooling around with this too. Probably a currency setting or something, but my (dwrd(var)) looks like six and 00/100 . So you'd have to substitute the ' dollars and zero cents' with whatever you may get in the (SRPL....) function.
-----Original Message----- From: James Hageman [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 08, 2005 12:27 PM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: Converting Integers to Text Value Try something like ... set var v1 text= '6' set var v1 = (dwrd(.v1)) set var v = (SRPL(.v1,' dollars and zero cents',NULL,0)) James > > select inwgt,'The value for in weight is ' & (DWRD(inwgt)) & 'pounds' > from prodmast > > will produce this: > > inwgt ('The value for in weight is ' & (DWRD(inwgt > > --------- > ----------------------------------------------------------------- > > 126 The value for in weight is one hundred twenty-six pounds > 126 The value for in weight is one hundred twenty-six pounds > 126 The value for in weight is one hundred twenty-six pounds > 126 The value for in weight is one hundred twenty-six pounds > 126 The value for in weight is one hundred twenty-six pounds > > > Is there an RBase function to convert an integer to its text > equivalent? I want a report to write out "For the six months > ending..." rather than "For the 6 months ending". Have I overlooked a function? > Thanks. > Jan > >
