Trim after special character

Question

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

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

Aaron Ingold SSCrazy Eights Points: 9070 More actions · Answer 1

SELECTLEFT(value, CHARINDEX('/', value) - 1)

FROM table

That should do it...

Richard Sabbara Ten Centuries Points: 1382 More actions · Answer 2

Ten Centuries

Points: 1382

August 28, 2006 at 2:59 pm

It works perfectly! THANK YOU!

nigel. SSChampion Points: 11636 More actions · Answer 3

Note: This won't work if any of the values does NOT contain a '/'.

In this case charindex(value,'/')-1 evaluates to -1 causing LEFT to blow up with an invalid length error.

You'll need to add a case something like:

select left(value,
    case charindex(value,'/')
    when 0 then
       len(value)
    else 
       charindex(value,'/')-1
    end)
from table