Thank you guys, I owe you a beer

Once again forgive the newb in me...

But the SELECT 'whatever' UNION ALL part...

Is that a necessary or were you using it as an example?

.. that data was just an example,...

Well out of those examples I would say:

DanceContest

SongContest

ContestGuitar

would be the values i would like returned..

Granted if the only way to do it is by several characters (say the first or...

Camel case ftw, I use the same method for all my programming and seems pretty standard in the Open Source scripts I use

Thank you very much Matt,

I really didn't wanna convert everything to mysql 😉

Holy ouch batman...

so if I did use the CAL approach it would actually run slower aka 1 query at a time?

11k for SQL seems retardingly steep...

Was liscensing always this way?...