SQL CHAR() | CHAR() Function
The SQL CHAR() | CHAR() is a function, and return a character (ascii value) that represent of a given input number from query result.
The SQL CHAR() | CHAR() function supports only numeric value which contains the ascii table.
It can be used in SELECT statement as well in where clause.
SQL CHAR() Syntax
For MS ACCESS / ORACLE
// Ascii value from a given input numeric value
SELECT CHAR(input_numeric_code);
// Ascii value from a given input numeric table column
SELECT CHAR(input_numeric_code_column) FROM table_name;
For SQL SERVER / MySql
// Ascii value from a given input numeric value
SELECT CHAR(input_numeric_code);
// Ascii value from a given input numeric table column
SELECT CHAR(input_numeric_code_column) FROM table_name;
Search Keys
- sql chr function
- sql server chr
- ascii chr 10
- chr function
- sql to char
- sql character functions
- sql char function
- sql char 10
- oracle character functions
SQL CHAR() Example - Using Expression Or Formula
The following SQL SELECT statement returns the character(ascii value) of a given input number.
SELECT CHAR(65) AS 'Ascii Character Of 65';
The result of above query is:
SQL CHAR() Function More Example
| Input Value |
Result |
| CHAR(67) |
C |
| CHAR(98) |
b |
| CHAR(50) |
2 |
| CHAR(50 + 15) |
A |
Sample Database Table - Customer
| CID |
CName |
Age |
City |
| 65 |
Suresh Babu |
72 |
Nasik |
| 66 |
Suresh Kumar |
56 |
Nasik |
| 67 |
Vinoth Kumar |
78 |
Chennai |
| 68 |
Azagu Varshith |
83 |
Madurai |
| 69 |
Haris Karthik |
103 |
Bangalore |
| 70 |
Kishor Kumar |
109 |
Chennai |
SQL CHAR() Example - With Table Column
The following SQL SELECT statement find the ascii value of a given table column "CID" from the "Customer" table:
SELECT
CID, CHAR(CID) As 'Ascii Character Of CID',
Age, CHAR(Age) As 'Ascii Character Of Age'
FROM Customer;
The result of above query is:
| CID |
Ascii Character Of CID |
Age |
Ascii Character Of Age |
| 65 |
A |
72 |
H |
| 66 |
B |
56 |
8 |
| 67 |
C |
78 |
N |
| 68 |
D |
83 |
S |
| 69 |
E |
103 |
g |
| 70 |
F |
109 |
m |