select url="http://localhost:53853/www.baidu.com" select right(url,charindex('/',REVERSE(url))-1) 结果:www.baidu.com