>>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," ","")
Wouldn't the ChrTran() function be (at least theoretically) faster for such things. It sure is when you have to filter out several unneeded characters, like turning a 'TRG(011)-4/TG H+77K' to become 'TRG0114TGH77K', you can
REPLACE ALL partnumber WITH ChrTran(partnumber," +-/()","")
...but for removing just spaces, I wonder. Also not sure what would be a proper test.