提取图中红框部分
------解决思路----------------------
declare @str varchar(8000)
select @str=isnull(@str+',','')+substring(pt,LEN(pt)+2-charindex('/',reverse(pt)),charindex('.',pt)-LEN(pt)-2+charindex('/',reverse(pt))) from (select distinct pt from vc) as t
print @str