Just take a look at the COMPRESS() function...
Paul M. Dorfman
>From: Alvin Igonia <aigonia@CA.IBM.COM>
>Reply-To: Alvin Igonia <aigonia@CA.IBM.COM>
>Subject: converting string (spaces) to numeric
>Date: Tue, 26 Aug 2003 12:22:22 -0400
>Has anyone ever converted a string to numeric (ie. '1 000 000' to 1000000).
>I have a program I am trying to modify. The data has change. We use to
>read the data string without any spaces but now it contains spaces.
>I don't really want to do a do-loop and check for spaces but if it's the
>only way, i guess i will have to.
MSN 8: Get 6 months for $9.95/month. http://join.msn.com/?page=dept/dialup