[RESOLVED] Replacing Left of a character

[Always_Confused]

I need everything to the left of the forward slash and the slash it self. I will not rule out the the string may be TAG/ 123AB23 or TAG/ WE4051 or AB422/ 1234567890

[CVMichael]

You are contradicting yourself, in the first post you said you need the numbers, now you say you want everything to the left of slash....

But I think you mean everything AFTER the slash ? right ?
Something like this maybe ?

SELECT LTRIM(SUBSTRING('AB422/ 1234567890', CHARINDEX('/', 'AB422/ 1234567890') + 1, 1000))

[Always_Confused]

That it!!!!!

Thank you!!!!