declare @SearchString varchar(100)
set @SearchString = '*411221211*222'
select charindex('*',@SearchString,CHARINDEX('*',@SearchString,1)+1)

IF LEN(@string) - LEN(REPLACE(@string, '*', '')) >= 2
BEGIN
	RETURN LEN(@string) - CHARINDEX('*', REVERSE(@string)) + 1
END

Select CHARINDEX('*',@InputString,CHARINDEX('*',@InputString, 1) + 1)