How to redirect to a different URL based on node content while loading a node
Ah ha... and I just learnt about row and field level templating in Views... isn't views incredible?!

I followed the instructions here http://drupal.org/node/352970 and can alter the link and it's text based on the context of each row.

Super!