I don't know of any built-in function...but by using the AT() function and LEN() and SUBSTR(), you should be able to come up with something...
Take care
>Is there a quick way to remove blanks within a field? For example PART NUMBER = 'TRG 011 4TGH 77K' to become 'TRG0114TGH77K'
>Thanks.
Joseph C. Kempel
Systems Analyst/Programmer
JNC
