Assuming the data in the text field will resemble any of the following.
Brian K. Avis
Brian Avis
Brian
Or whatever combo.
Brian Avis wrote:
> I want to run a SELECT on a text field and match any of the following.
>
> brian
> Brian
> BRIAN
>
> Or any other combination. How do I tell SQL to ignore case when
> doing a SELECT?
>
>
--
Brian Avis
SEARHC Medical Clinic
Juneau, AK 99801
(907) 463-4049
Have a nice diurnal anomaly!