<div>
select substring( yourfield, len(yourfield) - charindex('_', reverse(yourfield)) &nbsp;- 1, len(yourfield)
</div>


select substring( yourfield, len(yourfield) - charindex('_', reverse(yourfield))  - 1, len(yourfield)

<div>
<br />
select REVERSE(LEFT(REVERSE(Col),<wbr /> CHARINDEX('_', REVERSE(Col), 1)-1))
</div>



select REVERSE(LEFT(REVERSE(Col), CHARINDEX('_', REVERSE(Col), 1)-1))

<div>
angelIII,<br />
<br />
This may work for most of the data, but for some reason a string like : abcdefg_test_testtest_382<br />
&nbsp;brings back &quot;82&quot;<br />
<br />

</div>


angelIII,

This may work for most of the data, but for some reason a string like : abcdefg_test_testtest_382
 brings back "82"



<div>
ewanqoya,<br />
<br />
I ran your sql and keep getting the error :<br />
Invalid length parameter passed to the SUBSTRING function.
</div>


ewanqoya,

I ran your sql and keep getting the error :
Invalid length parameter passed to the SUBSTRING function.

<div>
angelIII,<br />
<br />
got it, many thanks works great
</div>


angelIII,

got it, many thanks works great

<div>
<br />
H-SC<br />
I dont use SUBSTRING in my solution<br />
<br />
SELECT REVERSE(LEFT(REVERSE(Col),<wbr /> CHARINDEX('_', REVERSE(Col), 1)-1))
</div>



H-SC
I dont use SUBSTRING in my solution

SELECT REVERSE(LEFT(REVERSE(Col), CHARINDEX('_', REVERSE(Col), 1)-1))

<div>
ewanqoya,<br />
hmm, not sure but I indeed still get that exception.
</div>


ewanqoya,
hmm, not sure but I indeed still get that exception.

<div>
<br />
Very interesting<br />
<br />
But angelIII's solution works for you already
</div>



Very interesting

But angelIII's solution works for you already

<div>
ewanqoya,<br />
<br />
I know, I just like to follow up with everyone who responds to the post out of respect. &nbsp;many thanks for your help here as well. &nbsp;take care :)
</div>


ewanqoya,

I know, I just like to follow up with everyone who responds to the post out of respect.  many thanks for your help here as well.  take care :)

<div>
<div class="content wysiwyg-content">
I have a table that has many rows of data like the following ... <br />
abcdefg_524_test_testtest_<wbr />32<br />
4_abcdefg_test_testtest_32<wbr /><br />
abcdefg_test_testtest_382<br />
abcdefg_test_tes_ttest_32<br />
<br />
I need to get the set of numbers after the last &quot;_&quot; in the string. &nbsp;How can this be done?<br />
<br />
<br />

</div>
</div>


I have a table that has many rows of data like the following ... 
abcdefg_524_test_testtest_32
4_abcdefg_test_testtest_32
abcdefg_test_testtest_382
abcdefg_test_tes_ttest_32

I need to get the set of numbers after the last "_" in the string.  How can this be done?




Extract everything after a certain character

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.