SQL SERVER – ASCII to Decimal and Decimal to ASCII | Journey to SQL Authority with Pinal Dave

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… Continue Reading...

Source: SQL SERVER – ASCII to Decimal and Decimal to ASCII | Journey to SQL Authority with Pinal Dave