SQL Query Parse String
Posted on 2010-09-13
I have a field that is a string of text divided by a hypen. See example:
I need to pull the letters after the first hyphen only. Letters can be in 2, 3, 4, or whatever.
I tried substring, but then it would only pull certain characters with a set position. Was thinking of using charindex, but I can't seem to get it to work correctly.. Can someone provide me a query to pull letters after the first hyphen and nothing after the 2nd hyphen?