Sql server substring before last occurrence of character. NET System. Jun 13, 2012 ...
Sql server substring before last occurrence of character. NET System. Jun 13, 2012 · If you want to get this out of your table using SQL, take a look at the following functions that will help you: SUBSTRING and CHARINDEX. ' that appears after that '/'. Dec 10, 2016 · SELECT LEFT(assocname, LEN(assocname) - CHARINDEX('>',REVERSE(assocname))) So we're reversing it, finding the first '>', then subtracting that from the length to find how far that character is from the beginning. Ends immediately before the first '. Then take all characters up to that point. Jan 9, 2026 · The SUBSTRING function returns a portion of a specified character, binary, text, or image expression. The Oracle / PLSQL INSTR function returns the location of a substring in a string. Oct 21, 2013 · 1 I've been working on something similar and after a few tries and fails came up with this: Example: STRING-TO-TEST-ON = 'ab,cd,ef,gh' I wanted to extract everything after the last occurrence of "," (comma) from the string resulting in "gh". You can use those to trim your entries. omkrj gzna xshpy yfakelp gyxpv yzcsiqd hhoqpse atydfj xzzychm uabb
