Stripping a string

Question

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

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

Jeremy Kemp SSCertifiable Points: 6754 More actions · Answer 1

Use the REVERSE function to turn the string around, then SUBSTRING based on the position of the now first hypen and REVERSE it back:

select reverse(substring(reverse('souph-0-97'),1,charindex('-',reverse('souph-0-97'))-1))

Jeremy

Jeremy Kemp SSCertifiable Points: 6754 More actions · Answer 2

Another thought, if you know that there are always 2 digits, you could use the RIGHT function:

select right('souph-0-97',2)

cedar72 Say Hey Kid Points: 711 More actions · Answer 3

Jeremy,

You're right on LOL I was just returning to say that I figured it out and that was the exact solution I got...thanks though!