Thanks, Dawn, James and Mike. I did know about the dwrd command. I tried locating the first space in the string and sgetting the chars before the space and got all kinds of whacky error messages (out of internal space to process, etc.). I think changing the currency settings temporarily may be the best route! Thanks again for all the input! Jan
----- Original Message ----- From: "Dawn Oakes" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Tuesday, February 08, 2005 12:50 PM Subject: [RBG7-L] - RE: Converting Integers to Text Value 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 > >
