Re: SELECT question

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!