Thanks for all your replies - much appreciated. As it turns out you can use dynamic SQL to exec a cursor declare statement and it works. Who woulda thunk.
Ahh, sorry, that was just a cut-down snippet of the select statement. Theres about 20 columns in the table and I need to do row based transformations based on business...