How do you type cast a numeric value over a char in a SELECT statement? I am trying to retrieve only records with values between 100 and 999 in a char type column. BETWEEN doesn't work ( I assume because it is looking at the ASCII equivalent). Can anyone help?