Nigel Weeks wrote:

>>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.
>
>

I thought it was standard.

see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.5.0 - Release Date: 02/06/2005