Kam:

This would work with both CASE and IF statements. THANKS!!!

Mal

>My opinion is which ever one you use i.e. either CASE Statement or IF statement, you should put the option which has the highest chance to happen in the top and then the second highest chance option next and so on ... and the least in the last.
>This way you could achieve the best efficiency in your code in the long run.
>
>
>Kam.