• declare @SearchString varchar(100)

    set @SearchString = '*411221211*222'

    select charindex('*',@SearchString,CHARINDEX('*',@SearchString,1)+1)