Stripping a String
I'm looking to strip down a string based on position of character and display it as a column.
Owner Name Field (Company Name\UserLogInName)
Now I'd like to only display everything after '\'. Result should be
I looked at CHARINDEX/POSITION option and was able to create a column which gives me position of '\' for each record. I was trying to use position in substring but it doesn't seem to allow me to do that.
Looking for something like below:
Appreciate your assistance please.