RB Smissaert wrote:
Ok, now done some better testing and the method with CASE WHEN is indeed, as expected a bit faster....
To me the lookup table method seems like exactly what a relational database is used for.
The CASE WHEN would have to be dramatically faster, and in an area where timing was critical, for me to choose that way. If there were thousands of items, and changes were frequent, you wouldn't even consider CASE WHEN, would you?
Remember: timing isn't important, except when it is. Gerry ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
