ok, i figured it out. i guess you do need to seperate the fields in the case statements based on their datatype.

here is an article

http://databases.aspfaq.com/database/how-do-i-use-a-variable-in-an-order-by-clause.html