82问答网 > sql2008中截取字符串

sql2008中截取字符串

如一字符串为 1234 and rieo,如何截取and之前部分和之后部分

2025-03-23 23:10:39

推荐回答（1个）

回答1：

declare @str varchar(100)
declare @subStr1 varchar(50)
declare @subStr2 varchar(50)
declare @and varchar(50)
set @and = 'and'
set @str = '1234 and rieo'

declare @index1 int
declare @index2 int

set @index1 = CHARINDEX(@and,@str)
set @index2 = len(@str)-charindex(@and,@str)-LEN(@and)
set @subStr1 = substring(@str,1,@index2)

set @index1 = charindex(@and,@str)+ LEN(@and)
set @index2 = len(@str)+1

set @subStr2 = substring(@str,@index1,@index2)

select @subStr1 A,@subStr2 B