SQL Select everything after character

sql sql-server-2016
coblenski picture coblenski · Aug 16, 2016 · Viewed 60.1k times · Source

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

Gordon Linoff picture Gordon Linoff · Aug 16, 2016

You can use:

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

Related questions

Is there a LastIndexOf in SQL Server?

I am trying to parse out a value from a string that involves getting the last index of a string. Currently, I am doing a horrible hack that involves reversing a string: SELECT REVERSE(SUBSTRING(REVERSE(DB_NAME()), 1, CHARINDEX('_…

Read More
SQL Replace multiple different characters in string

I need to replace multiple characters in a string. The result can't contain any '&' or any commas. I currently have: REPLACE(T2.[ShipToCode],'&','and') But how do you put multiple values in? Many thanks!

Read More
STRING_AGG is not a recognized built-in function name

I've downloaded and installed SQL Server 2016. When I attempted to use the STRING_AGG function I receive this error. Here is my code: SELECT STRING_AGG(cast(FieldNumber AS VARCHAR(100)), ',') FROM Fields I've installed SQL Server 2016 and SP1. …

Read More