A good question that has taught me two things:
1. You can't trust SQL's ISNUMERIC function
2. You can build a recursive CTE - although I'm no sure I would want to ;-)
If anyone else has examples of CTE's I bet they'd make for some tricky questions?