Posted by laurenq uantrell on 11/11/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.

• Next in forum: Re: QUESTION: No Support for SQL 2K on W2K3??
• Prev in forum: Parse Return value of SYSTEM_USER
• Thread view: Re: Parse Return value of SYSTEM_USER

[Reply to this message]