SQL Select everything after character

Question

I'd like to select everything AFTER a certain character (-) that is placed on the most right side.

Eg.

abcd-efgh-XXXX 

And I'd like to select the XXXX part

Thanks!

Answer 1

You can use:

select right(col, charindex('-', reverse(col)) - 1) 

Answer 2

DECLARE @x varchar(100) SET @x = 'abcd-efgh-XXXX' SELECT RIGHT(@x, CHARINDEX('-', REVERSE(@x)) - 1)