What I want to do is remove part of a result from a query. I am selecting the srvname from sysservers as follows.

SELECT srvname from sysservers
Where srvid ='0'

When the name is returned some times it might be like servername\instance. What I need to do is cut off the \ and everything after that so that my result is just servername. I am then using this result in a cursor to go after server shares. The length of the servername varies. Any suggestions.