Tom,
select * from mytable where


upper(myfield) = upper(mystring)
atc(mystring,myfield) > 0

Note: The first expression would be optimizable given an index using UPPER(). The second would not be.

HTH.

>I have a table full of mixed case data. I need to search using lowercase.
>
>cString = madonna
>
>I need to extract things like:
>
>madonna
>Madonna
>MADONNA
>
>and things of this nature. I know this is probably dumb. But I can't remember how to search in the mixed case. I tried using likec()- But then I matched nothing at all.
>
>At least with 'brow for fieldname = cString' I get every lowercase cString.
>
>Heeelp!
>
>Thanks
>Tom Welch