Posted by laurenq uantrell on 11/16/03 11:32

I know I can do:

DECLARE @UserNameWithDomain nvarchar(100)
SELECT @UserNameWithDomain = SYSTEM_USER

DECLARE @UserNameNoDomain nvarchar(100)
SELECT @UserNameNoDomain =
SUBSTRING(@UserNameWithDomain,CHARINDEX('\',@UserNameWithDomain)+1,100)

I'm hoping for something more aesthetic.

[Back to original message]