Hi RBS,
Perhaps the alternative form of the CASE statement would be faster
What form is that?
The form that I showed in my previous email. That is, using:
case ENTRY_TYPE
when 9 then 'Issue
when 2 then 'Note'
etc
instead of:
case
when ENTRY_TYPE = 9 then 'Issue
when ENTRY_TYPE = 2 then 'Note'
etc
Tom
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------