The others gave examples of you to make the initial changes, but how in the world would you figure out how to put the same number of spaces back when you are done? If you need that then you should copy the data to a temp table, make your changes, then repopulate the fields with the data from the temp table.


>hey everyone,
>i have a series of tables which need to be corrected. the problem is that the tables have a column which the path is stored. the data within the column looks like the following:
>
>(the hyphens represent spaces)
>c:\something-----c:\something\somethingelse------c:\something\somethingelse\this
>
>
>
>i need to replace the c: with d: and also make some other changes. the changes will be uniform through-out all the programs.
>
>how do i take the spaces out of the table, make the corrections, and then restore the table back to the way it was with the new corrections(i.e. add the correct number of spaces back)? any help would be appreciated. thank you.