NCHAR Function in SQL

The NCHAR string function shows the unicode value of the integer passed in the function. This function takes only one parameter or argument. If we pass the integer value which exceeds the given range then it shows NULL value.

Syntax of NCHAR String Function

In SQL, we can use the NCHAR function with the columns of the table, strings, and characters.

Syntax1:

In this syntax, we used the NCHAR function with existing table of SQL. Here, we have to define the name and integer column of that table on which we want to perform NCHAR function.

Syntax2:

In this syntax, we used the NCHAR function with the integer value.

Examples of NCHAR String function

Example 1: The following SELECT query shows the Unicode value of 20:

Output:

Example 2: The following SELECT query shows the Unicode value of 84:

Output:

Example 3: The following SELECT query shows the Unicode value of 260:

Output:

Example 4: This example uses the NCHAR function with the table in Structured Query Language.

In this fourth example, we will create the new table through which we will perform the NCHAR function with table values:

The following block shows the syntax to create the new table in SQL:

The following CREATE statement creates the Fresher_Marks table:

The below INSERT queries insert the records of freshers with marks and details in the Fresher_Marks table:

The following SELECT statement displays the inserted records of the above Fresher_Marks table:

Query 1: The following SELECT query uses the NCHAR function with the Fresher_ID column of the above Fresher_Marks table:

This SQL statement shows the Unicode value of id of each fresher from the above table:

Output

Query 2: The following SELECT query uses the NCHAR function with the Aptitude_Marks column of the above Fresher_Marks table:

This SQL statement shows the Unicode value of aptitude marks of each fresher from the above table:

Output:

Query 3: The following SELECT query uses the NCHAR function with the Reasoning_Marks and Technical_Marks column of the above Fresher_Marks table:

This SQL statement shows the Unicode value of reasoning and technical marks of each fresher from the above table:

Output:

Query 4: The following SELECT query uses the NCHAR function with the Percentage column of the above Fresher_Marks table:

Output: