1. CHR() Function :
The Chr() function returns the character for the given ASCII number code. The Chr function takes an integer as a parameter and returns the respective character. It works opposite to ASC() function.
Chr(ASCII number code)
Parameter – Required; An integer.
Return – A character.
SELECT Chr(75) AS NumberCodeToCharacter;
2. ASC() Function :
The ASC() function returns the ASCII value of the character. If more than one character is passed in the function then it will return the ASCII value of the first character otherwise ASCII value of the specified character.
Parameter – Required; A character or a string.
Return – ASCII value; An Integer value.
Table – Student
|XYZ||DSA SELF PACED|
SELECT STUDENT, Asc(STUDENTNAME) AS NumCodeOfFirstChar FROM STUDENT;
Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.
- PLSQL | CHR Function
- Hex() and Oct() Function Function in MS Access
- SLN() and SYD() Function Function in MS Access
- DDB () and FV() Function Function in MS Access
- Val() and Sum() Function in MS Access
- Sgn() and Sqr() function in MS Access
- StrConv() and StrReverse() Function in MS Access
- InStr() and InstrRev() Function in MS Access
- LCase() and UCase () Function in MS Access
- Str() and StrComp() Function in MS Access
- Replace() and Space() Function in MS Access
- Exp() and Count() Function in MS Access
- Mid() and Len() Function in MS Access
- LTrim() and RTrim() Function in MS Access
- Left() and Right() Function in MS Access
- Rnd() and Round Function in MS Access
- Max() and Min() function in MS Access
- Fix() and Format() Function in MS Access
- Second() and Time() Function in MS Access
- MonthName() and Now() function in MS Access
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to email@example.com. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.