I forgot about the STRTRAN() function.

Way to go Fast Eddie. ;-)




>>Is there a quick way to remove blanks within a field? For example PART NUMBER = 'TRG 011 4TGH 77K' to become 'TRG0114TGH77K'
>>Thanks.
>
>REPLACE ALL partnumber WITH strtran(partnumber," ","")