Understanding the ASCII() Function in SQL Server: A Complete Guide
☰Fullscreen
To find the ACII Code of capital letter 'A'
Syntax:
<span class="pln"> ASCII</span><span class="pun">(</span><span class="typ">Character_Expression</span><span class="pun">)</span><span class="pln"> </span>
It returns the ASCII code of the given character expression.
Code:
<span class="pln"> </span><span class="typ">Select</span><span class="pln"> ASCII</span><span class="pun">(</span><span class="str">'A'</span><span class="pun">)</span><span class="pln"> </span>
Output:
The above code will produce the following result-
<span class="pln"> </span><span class="lit">65</span><span class="pln"> </span>
No Questions Data Available.
No Program Data.