I'm a computer programmer and that works fine as long as they don't bother me with meetings :P. Programming works great because I can hyperfocus on that really well - but getting pulled out of it is physically painful. So my reviews are mixed ... I seem to deliver a good job but distract others by fidgeting, wobbling my legs or singing, suddenly laughing as I think of something silly and am grumpy when ppl distract me. In some work places it worked, in others it did not. It really depends if people are willing to put up with your ADD traits and value the strong points like creativity, being a problem solver, an idea generator and whatnot.
And like gtrplayer says, it is essential that you have some sort of autonomy. Could be self-employed, although the idea of having to do the financial administration of even a 1 person company completely terrifies me
Peace
Luthien