[最佳答案] An example done in SQL server, which may help you. declare @myString varchar(50) set @myString = 'sadfa*lkj*234r2*' declare @startPosition int declare @endPosition int --First * location select @startPosition = Charindex('*', @myString, 0) --Second * location select @endPosition = Charindex('*', @myString, @startPosition+1) select @endPosition select substring(@myString, @startPosition +1 , @endPosition - @startPosition -1)