try this

SELECT REPLACE(SUSER_NAME(), HOST_NAME() , '\','') as userId

i hope it works..

i have mine setup as

SELECT REPLACE(SUSER_NAME(), 'Dom-cs\','') as userId