Posted by laurenq uantrell on 10/03/30 11:32

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

• Next in forum: Re: Parse Return value of SYSTEM_USER
• Prev in forum: DBGEN TPCH Compiling
• Thread view: Parse Return value of SYSTEM_USER

[Reply to this message]