截取特殊符号后头的字符串_ASP.NET

截取特殊符号后面的字符串
字符串：我一口就把水给喝了/厉害
sql中，怎么截取"/"后面的字符串

------解决方案--------------------------------------------------------

SQL code

declare @s nvarchar(50)set @s='我一口就把水给喝了/厉害';select substring(@s,charindex('/',@s)+1,len(@s)-charindex('/',@s))
------解决方案--------------------------------------------------------
string result=str.Split('/')[1];
------解决方案--------------------------------------------------------
SQL codeDECLARE @str nvarchar(2000)SET @str='我一口就把水给喝了/厉害'SELECT RIGHT(@str,LEN(@str)-CHARINDEX('/',@str))
------解决方案--------------------------------------------------------
SQL codedeclare @s1 as nvarchar(100)declare @result as nvarchar(100)set @s1 = 'ABCDEFGHIGK/LMASDFASDF';print @s1declare @pos as intset @pos = CHARINDEX('/', @s1, 0)set @result = RIGHT(@s1, LEN(@S1) - @pos)print @result