Search the Community
Showing results for tags 'substring'.
Found 1 result
-
I am trying to report 'Top Console User' by using a Sql substring and need to remove the "domain/" from "domain/username." Using the substring, I would like to only get back the username by removing everything before the forward slash. Searching the internet and these forums, I was unable to find something about using the "/" character. I have found some good articles on substrings but I cannot get the function to work with this character. Does anyone know how I could create a query to find top console user and remove the "domain/" ? Thank you in advance for the help! This is my first post, so please let me know if this should be posted in another forum. I'm using SQL Server 2008 R2 and Configuration Manager 2007
