From readability point of view one is a clear winner ...
>Thanks guys. I'll run some tests to see...
>
>
>>Either of them is not optimizable and will have to go through all the records in the table unless you have some additional conditions. Only tests can tell wich one will be faster.
--sb--