SQL Function: CHAR/CHR()

Definition:

Return the corresponding character of given ASCII code.

(Remark:This keyword exists in HKDSE ICT candidates’ reference sheet,but SQL-92 Standard does not include this function.)

---

Command Syntax:

CHAR(ASCII_code)

---

Command Example:

Input:

SELECT CHAR(73)+CHAR(67)+CHAR(84) AS Result;

Output:

Result
ICT

---

‘Does this function really exist in exam???’By secondary 6 student