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?

Thanks