Nigel Weeks wrote:

>>Also, tt may be important to note that neither your option,
>>nor this one
>>can use an index, a table scan will occur.
>
>
> You answered it right there! Because 'containing' is always going to do a
> table scan, doing the XOR to the uppercase version was a tiny overhead
> compared to the table scan it's gonna do anyway...
>

Err.... last I checked, you couldn't index a blob field... regardless of
case sensitivity, upperness etc.


Regards,


Ann