ASCII - Returns the ASCII code value of the leftmost character of a character expression.
CHAR - Fixed-length non-Unicode character data with length of n bytes.
Examples:
----Decimal to ASCII SELECT CHAR(80)+CHAR(73)+CHAR(78)+CHAR(65)+CHAR(76) AS SQLAuthorityAuthor GO----ASCII to Decimal SELECT ASCII('P') AS SQLAuthorityAuthor UNION ALL SELECT ASCII('I') UNION ALL SELECT ASCII('N') UNION ALL SELECT ASCII('A') UNION ALL SELECT ASCII('L') GO
Refer the ASCII-Decimal Table here.
Reference : Pinal Dave (http://www.SQLAuthority.com)
pinaldave
fentastic boss
hi
quert for
ascii code to character
(ex: select ASCII(’a”) this is char to ascii)