Removing leading and trailing blanks

[Peping]

Need some help on how to remove leading and trailing blanks on a field record i.e. "AAA BBB CCC" to "AAABBBCCC" as ALLTRIM can't do the trick. Thanks in advance..

 

[cslawtom]

X = STRTRAN("AAA BBB CCC"," ","&quot

 

[EBOUGHEY]

I use the below command all the time when I am cleaning up address and name data...

REPLACE ALL [FIELDNAME] WITH STRTRAN([FIELDNAME]," ","&quot

ie: REPLACE ALL LAST WITH STRTRAN(LAST," ","&quot