Parse Return value of SYSTEM_USER

[laurenq uantrell]

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

value returned is "Domain\NTSignonName"
What I want is only "NTSignonName"

Is there a function to do this or an easy parse for this in SQL2000?

lq

[laurenq uantrell]

I know I can do:

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

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

I'm hoping for something more aesthetic.

[Erland Sommarskog]

laurenq uantrell (la*************@hotmail.com) writes:

I know I can do:

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

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

I'm hoping for something more aesthetic.

I don't know if it's more esthetic, but parsename() is an alternative.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx