[RBG7-L] - RE: Converting Integers to Text Value

[Ramsour Mike]

Jan:   I replied too hastily.  The function that will convert text to words is DWRD.    You can then conacatenate this something like   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   I hope that helps more.   Mike -----Original Message----- From: Jan Barley [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 08, 2005 11:35 AM To: rbg7-l@rbase.com Subject: [RBG7-L] - Converting Integers to Text Value 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