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?