把前4位替换成空格stuff(col1,1,4,'')
declare @str varchar(100)set @str='http://zhidao.baidu.com/question/273075839.html'select Substring(@str,5,len(@str))-----------------------------------1楼的办法也很不错
SUBSTRING(Title, 5, 1000)