Is there a reverse string search function in SQL Server 2008 or higher? I want to search a character from the end to the beginning of a string. The function needs to return the position at which the character is found. If there is no such built-in function, could someone please show me the code on how to do it programmatically?
So there's no built-in function and I have to reverse the string before I search with CharIndex. It would have been nice -- and faster too -- if there's already a built-in function to do this.
Well - you could always create a computed column as the REVERSE of the actual column, index the computed column and then perform a normal CHARINDEX/PATINDEX on that reversed column.