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]
|