[update]
Believe it or not I did this and it worked;
update Part set Filename = (select replace(Part.Filename, rtrim(Part.Filename, replace(Part.Filename, '\', '')), ''))
by removing the
from Part from the query it updates nicely!
Thanks everyone for your input!
[/update]