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

[Ramsour Mike]

It has to do with your currency settings and such.  In my database I don't show cents on currency data types.  (Long story -- I won't go there).  At any rate, DWRD works well with integer types data too.   Mike -----Original Message----- From: Adriana Montano [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 08, 2005 12:05 PM To: rbg7-l@rbase.com Subject: [RBG7-L] - RE: Converting Integers to Text Value I thought that DWRD only produced currency values like 'one hundred twenty six dollars and zero cents.' Did I miss a step to truncate the 'dollars and zero cents' part? From: rbg7-l@rbase.com [mailto:[EMAIL PROTECTED] On Behalf Of Ramsour Mike Sent: Tuesday, February 08, 2005 10:56 AM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: Converting Integers to Text Value 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