Sql server ASCII function

 In this article I am going to explain sql server ASCII function.

In previous article I have explained how to view code of store procedure in Sqlserver, how to implement button click event in Angularjs and how to get dateand time from current date in Sql server.

Description:

ASCII stands for American Standard Code for Information Interchange.  It returns the numeric value of left most character.

Syntax

ASCII ( character_expression )    

Example: 

select ASCII('A') as 'ASCII Value'

select ASCII('Articlemirror.in') as 'ASCII Value'

select ASCII('a') as 'ASCII Value'

Output:

v    Note: If more than one character is entered, the ASCII function will return the value for the first character and ignore all after first.