Chapter 15: Using the Built-In Functions in Queries

user_name

This query finds the row in sysusers where the name is equal to the result of applying the system function user_name to user ID 1:

select name 
from sysusers 
where name = user_name(1)

name
------------------------ 
dbo
 
(1 row affected)