SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Prasad Bhogadi / Function To Retrieve Last Index / Latest Posts

RE: Function To Retrieve Last Index

jonegerton — Mon, 25 Jul 2011 09:31:13 GMT

I'm not sure a function is required for this. Have you considered:[code="sql"]declare @ToFind varchar(10)declare @InString varchar(20)set @ToFind = 'llo'set @InString = 'Hello World, Hello World'select LEN(@InString) - CharIndex(reverse(@ToFind),reverse(@InString)) - 1[/code]This returns: 16

RE: Function To Retrieve Last Index

shannonholck — Mon, 21 Dec 2009 17:47:36 GMT

I didn't compare head to head, but I would think something like this might perform better with longer strings:[code="other"]-- NOTE: this uses the len function, so this function ignores whitespace at end alsoCREATE FUNCTION dbo.LastIndexOf( @char as char , @string as varchar(max))RETURNS integerAS BEGIN SET @string = rtrim(@string) if len(@string) = 0 return 0 DECLARE @revString as varchar(max) DECLARE @lastIndex as integer SET @revString = reverse(@string) SET @lastIndex = charIndex(@char, @revString) -- find the last char in the reverse string IF @lastIndex = 0 return 0 SET @lastIndex = len(@string) - @lastIndex + 1 -- flip it so counting from the front RETURN @lastIndexEND[/code]

Function To Retrieve Last Index

Prasad Bhogadi — Sun, 07 Oct 2007 08:42:19 GMT

Comments posted to this topic are about the item [B]Function To Retrieve Last Index [/B]