[sindiglo]

I think I have it!

SELECT * FROM teams where team_div='C' order by SUBSTRING(team_num,2)+0

Substring selects the remaining characters starting at the second. Then I convert the string to an integer by adding 0.

Bingo!

B) B) B)