0

On mysql we have the substring_index function:

SUBSTRING_INDEX(str,delim,count)

Definition: Returns the substring from string str before count occurrences of the delimiter delim. If count is positive, everything to the left of the final delimiter (counting from the left) is returned. If count is negative, everything to the right of the final delimiter (counting from the right) is returned. SUBSTRING_INDEX() performs a case-sensitive match when searching for delim.

I´ve found only created functions on sql server that works with positive count parameter like on this Stackoverflow topic:

SQL Server equivalent of substring_index function in MySQL

I need a function that works with the negative count. I will show some examples from what i need:

1)SUBSTRING_INDEX('AAA/BBB/CCC','/',-1) Result expected: CCC

2)SUBSTRING_INDEX('CCC','/',-1) Result expected: CCC

Does anyone know a function that i can create on sql server that implements this negative count like MySQL?

Thanks.

Community
  • 1
  • 1
guimarques8
  • 27
  • 2
  • 7
  • Write your own UDF? http://stackoverflow.com/questions/23854724/sql-server-equivalent-of-substring-index-function-in-mysql seems like there is [no direct equivalent](https://social.msdn.microsoft.com/Forums/en-US/210b3c9f-f7b3-4774-bf78-f95fd8410e26/using-substringindex-in-sql-server?forum=sqldataaccess): – xQbert Sep 01 '16 at 17:20
  • You may need to use "REVERSE" function twice when it's negative count. once to reverse the string get the value out then reverse it back to correct order. – xQbert Sep 01 '16 at 17:27
  • Thank you, xQbert. I will try here to write this UDF. – guimarques8 Sep 05 '16 at 19:42

0 Answers0