Is there a function to convert a character to its ASCII equivalent?
Is there a function to conver a character to an ascii number? In the end I need to translate a character based column in data into its numerical equivalent. They always happen to be 1 or 2 digits. So effectively "A" becomes 1"Z" becomes 26"AA" becomes 27"AB" becomes 28 etc. So say DIE_COLUMN = "CA" I want to return 79 I've come up with the following thoroughly ugly formula... but if there was ...