The UNICODE function in SQL returns the Unicode code point (integer value) of the first character of a given string expression.

? Syntax

UNICODE(character_expression)

• character_expression: A string or character from which you want the Unicode code of the first character.

? Description

• Returns an integer representing the Unicode code point of the first character in the input string.

• If the input is an empty string, it usually returns 0 or NULL (depending on the database).

• Useful when you need to get the numeric Unicode value of characters for comparison or processing.

? Example

SELECT UNICODE('A') AS UnicodeValue;  -- Returns 65SELECT UNICODE('?') AS UnicodeValue;  -- Returns 937 (Greek Capital Letter Omega)SELECT UNICODE('?') AS UnicodeValue; -- Returns Unicode code point of emoji

Notes

• Supported in SQL Server and some other databases.

• Behavior or availability might vary across different SQL platforms.

• Some databases may use different functions (e.g., ASCII for ASCII codes).

If you want, I can show how to use UNICODE in practical queries or with specific SQL dialects!