Select Records after an underscore

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Sean Lange SSC Guru Points: 286590 More actions · Answer 1

Please post consumable data when posting. It makes this a lot easier.

Here are a couple of ways you can accomplish this:

with myData (SomeValue) as

(

select 'doe,john_ABCDEFG1' union all

select 'jones,mark_L9905555'

)

select *,

PARSENAME(replace(SomeValue, '_', '.'), 1),

SUBSTRING(SomeValue, patindex('%[_]%', SomeValue) + 1, len(SomeValue))

from myData

There are a number of other ways this could be accomplished but these are both pretty simple.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

UconnDBA Default port Points: 1439 More actions · Answer 2

I have used Substring and Charindex to take everything after or before a character. This link gives an example...