表A
F_ID F_path
1 D:\Bak\070428\music1\2007-05-06\133.mp3
2 D:\Bak\070428\music2\2007-05-08\122.mp3
3 D:\Bak\070428\music3\2007-05-09\155.mp3
怎么样把表A中的F_path改为相对路径?结果为
F_ID F_path
1 music1\2007-05-06\133.mp3
2 music2\2007-05-08\122.mp3
3 music3\2007-05-09\155.mp3
F_ID F_path
1 D:\Bak\070428\music1\2007-05-06\133.mp3
2 D:\Bak\070428\music2\2007-05-08\122.mp3
3 D:\Bak\070428\music3\2007-05-09\155.mp3
怎么样把表A中的F_path改为相对路径?结果为
F_ID F_path
1 music1\2007-05-06\133.mp3
2 music2\2007-05-08\122.mp3
3 music3\2007-05-09\155.mp3
--Update
Update A Set F_path = Stuff(F_path, 1, 14, '')
--Select
Select F_ID, Stuff(F_path, 1, 14, '') As F_path From A
set F_path=stuff(F_path,1,14,'')