查询以在sql中剪切varchar

I have the following table:

我有下表：

I would like to cut all entries in the p_path and remove the "~\"I woul