>the problem is and i should have been more specific is the table looks more like this:
>c:\path\_____c:\path\path\________c:\path\path\path
>
>the underscores represent spaces.
>really it is just the last one with the three paths that is missing the '\'. the other problem is that the path's are not always uniform. it will vary in length throughout this field pending on where i want to point it.
>thanks
James,
I must be missing something.
still
addbs(rtrim('c:\path\_____c:\path\path\________c:\path\path\path')) yields 'c:\path\_____c:\path\path\________c:\path\path\path\'
Gregory