>- see footer for list info -< Whatever you end up with, Allan, I'll just add that you may want to consider the performance implications of the alternatives (even if only one seems to "work" for you). Some SQL statements, especially of the sort you're considering, may not be able to use an index, or might not use an index. You just want to be aware that while you get a "right" answer, it may be very expensive. Just beware. :-)
/charlie _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
