Returns the user name for the specified user ID.

Syntax

USER_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

• USER_ID function [System]
• SUSER_NAME function [System]

Standards and compatibility

Example

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

SELECT USER_NAME( 101 );