Ah - I do have an index on it. It's a name though - not very like to chnage much.

Whoops, never mind, I got it to work. There wasn't any code, I just set up a varchar field in Enterprise Manager and pasted CASE WHEN TYPE='O' THEN ORGNAME ELSE...