John Cobby John Cobby - 10 months ago 89
SQL Question

SQL Select everything after character

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

You can use:

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