I have a string in the following format 'DOMAIN\username'.
I wish to trim the domain and the backslash from the string. I cannont simply use RIGHT() as we have multiple domains of varying length.
What is the most portable way to do this?
Thank you.
+4
A:
Select Right('DOMAIN\UserName', Len('DOMAIN\UserName') - Charindex('\', 'DOMAIN\UserName'))
Barry
2010-10-08 09:27:15
Why the downvote?
Barry
2010-10-08 11:08:36
Probably because this produces incorrect results.
LukeH
2010-10-08 11:37:47
@LukeH - so it does. Couldn't see that for looking. I've amended my answer now. Thanks.
Barry
2010-10-08 11:41:00
@Barry: Still broken! It coinicidentally works for this specific example, but what about `ANOTHERDOMAIN\username` or `DOMAIN\anotherusername`?
LukeH
2010-10-08 11:50:13
@LukeH - Wow, my brain is just not switched on today. Sorted it now.
Barry
2010-10-08 11:55:38
+2
A:
you can try:
select substring('DOMAIN\username', charindex('\' ,'DOMAIN\username')+1, len('DOMAIN\username'))
anishmarokey
2010-10-08 09:29:49