Logo 
Search:

SQL Server Articles

Submit Article
Home » Articles » SQL Server » String FunctionsRSS Feeds

UNICODE Function

Posted By: Sarita Patel     Category: SQL Server     Views: 2657

This article explains UNICODE function of sql server with examples.

UNICODE is used to get unicode of first character defined by the unicode standard from the specified string. It returns an integer value.


Syntax of UNICODE Function :

UNICODE ( 'ncharacter_expression' )

ncharacter_expression is a string of type nchar or nvarchar.

It returns an integer data type.



Examples of UNICODE Function :

Example 1 : Use of UNICODE function in select clause

SELECT UNICODE('Syntax-Example')

Output
83

Above example returns unicode value of first character 'S' from specified string.
  
Share: 

 
 
 

Didn't find what you were looking for? Find more on UNICODE Function Or get search suggestion and latest updates.

Sarita Patel
Sarita Patel author of UNICODE Function is from United States.
 
View All Articles

Related Articles and Code:


 
Please enter your Comment

  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].

 
No Comment Found, Be the First to post comment!