Case-insensitive SELECT

Apologies in advance for what is assuredly a naive question. I think I understand the SELECT...WHERE...LIKE query form (although I'm still not sure why, with ODBC at least, I must use % instead of *...or why it even works) But suppose I want to find all rows of "table" in which "field" is "Field Name".... I'd use "SELECT * FROM tale WHERE field='Field Name'" If I now wanted it to match on 'Field Name', "Field name", "field name", "Field" etc., but not "Field Value" I could do some string manipulations, and perform many selects. But is there a more efficient way of expressing wildcards (either in SQL or in PHP's interface to it)? (eg, I'd love to say field LIKE [F|f]ield[| [N|n]ame] or something like that) ----------------- David B. Small dbsmall@alumni.haas.org