Home Forums SQL Server 2005 Administering create function RE: create function

  • September 17, 2010 at 3:19 am

    #1222837

    IF LEN(@string) - LEN(REPLACE(@string, '*', '')) >= 2

    BEGIN

    RETURN LEN(@string) - CHARINDEX('*', REVERSE(@string)) + 1

    END