Thanks for all your input so far guys.

To address the relationship between the character table and the class table.

Each character can be assigned 1 class per level range....

Would putting the queries in a Sproc be faster? I thought both functions and sprocs parsed and pre-compiled the data. Meaning that performance would be better? Well maybe not functions...