79095656

Date: 2024-10-16 20:10:15
Score: 1.5
Natty:
Report link

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
Reasons:
  • Blacklisted phrase (0.5): Thanks
  • Low length (0.5):
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Low reputation (0.5):
Posted by: mandarin software