> returns all rows where description has the word 'computer' within the
> data regardless of case.
>
> 'Computer', 'COMpuTer', etc.
>
> neither is the case important in the input string literal after
> "containing".
> Of course, I have no idea why this is so, but it is.
>
> 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...

(This is if I've got the notes from the source right...)

Nige.