sql 去掉最后一个字符

SELECT WorkNo FROM SY_TrackNum WHERE WorkNo LIKE '%N+S'  

--UPDATE SY_TrackNum SET WorkNo = replace (WorkNo,'http://*.*.*.*','http://*.*.*.*') WHERE 1=1 

UPDATE SY_TrackNum SET [WorkNo] = SUBSTRING([WorkNo], 1, LEN([WorkNo]) -3) WHERE WorkNo LIKE '%N+S'