Returns the user name for the specified user ID.

Syntax

SUSER_NAME( [ user-id ] )

Parameters

Returns

LONG VARCHAR

Remarks

If you do not specify user-id, the user name of the current user is returned.

See also

• SUSER_ID function [System]
• USER_NAME function [System]

Standards and compatibility

Example

The following statement returns the user name for a user with ID 101.

SELECT SUSER_NAME( 101 );