>>>>Not directly in VFP, however, the foxtools library has the function Reduce(). That will handle the removal of spaces appropriately. You might want to look at my Extended Foxtools Help File (under Coding, Syntax and Commands) available in the UT download section.
>>>
>>>Again, you invoke the wrath of the WSH gods...how about:
>>>
>>>
oRegExp = CREATEOBJ("Vbscript.RegExp")
>>>oRegExp.Global = .t.
>>>oRegExp.Pattern = "\s+" && this matches any occurrances of space, tab, ff, CR
>>>cVar = oRegExp.Replace(cVar," ")
>>
>>Unintentionally, I assure you. I was more worried about the foxtools gods< g >.
>
>A likely excuse. And next time, you'll claim "The Devil made me do it!"
Oh, hardly. I confess pure ignorance of the expression parser. That and I've spent the last few days reading the SQL Server On-Line books and my head is starting to swim. If I can retain (not to mention use) 1/10th of what I've read, I'll be where I need to be.
George
Ubi caritas et amor, deus ibi est