>All these searches involve converting all fields to upper case, then

testing

>for a match - quite heavy on large numbers of records.
>
>It's far better to dedicate a field in your table to storing the upper case
>version of a field, and use that in your searches. That way, an index can

be

>used on it, and you save doing table scans converting the case before each
>comparison.

However if you actually need a 'contains' search whether that be with "LIKE"
or "CONTAINING", an index is not used regardless. Or am I mistaken here.

regards,
Kevin.