Returns the numeric user ID for the specified user name.

Syntax

USER_ID( [ user-name ] )

Parameters

Returns

INT

Remarks

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

See also

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

Standards and compatibility

Example

The following statement returns the GROUPO user ID.

SELECT USER_ID( 'GROUPO' );