InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 11:07:14 GMT20http://www.sqlservercentral.com/Forums/Topic988002-146-1.aspxthank you very muchFri, 17 Sep 2010 04:00:56 GMTriver1http://www.sqlservercentral.com/Forums/Topic988002-146-1.aspxUse this:[code="sql"]Select CHARINDEX('*',@InputString,CHARINDEX('*',@InputString, 1) + 1)[/code]Returns 0 if it doesn't find a second '*'.edit: too late :(Fri, 17 Sep 2010 03:19:38 GMTOliiiihttp://www.sqlservercentral.com/Forums/Topic988002-146-1.aspx[code="sql"]IF LEN(@string) - LEN(REPLACE(@string, '*', '')) >= 2BEGIN RETURN LEN(@string) - CHARINDEX('*', REVERSE(@string)) + 1END[/code]Fri, 17 Sep 2010 03:19:13 GMThallidaydhttp://www.sqlservercentral.com/Forums/Topic988002-146-1.aspx[code]declare @SearchString varchar(100)set @SearchString = '*411221211*222'select charindex('*',@SearchString,CHARINDEX('*',@SearchString,1)+1)[/code]Fri, 17 Sep 2010 03:17:55 GMTsteveb. http://www.sqlservercentral.com/Forums/Topic988002-146-1.aspxHI, I need to create a function that receives a parameter (string) and returns a value if there is a second '*' in the string.E.g: Function receives the string: *4112*21211222 returns number 6Other e.g Function receives the string: *411221211*222 returns number 11Other e.g Function receives the string: 411221211222 returns nothing, because there is no second *Can someone help me with the t-sql to do this?Thnak youFri, 17 Sep 2010 03:05:25 GMTriver1