I have a series of user records in the form "Lname, Fname (ABCD)
" where ABCD
is the division the user works in.
I need to be able to extract that substring so I can sort on it, count etc to I can see what divisions are using resources.
In MySQL I'd add something like this to my select statement: 'substring(name,-5,4) AS division
' to capture this and allow me to sort, count, etc.
On SQLSERVER I can't figure it out.
Can anyone help me?