Thanks for all comments that I learned from and I edited the query to be:
UPDATE DBPaths SET Path_Image = 'E:\pics2024' + RIGHT(Path_Image, (CHARINDEX('\', REVERSE(Path_Image)) )) from DBPaths
The result will be :
Path_Image
E:\pics2024\1.png
E:\pics2024\22.jpg
E:\pics2024\947141.JPG