search field into MySQL

Hi everyone, I'm encountering a problem searching a DB. I wish for the input to not be case sensitive. if someone looks for AA they may also type aa or aA or Aa. This one is simple because its 2 or three letters. I also have entries that contain "Aviation Management Corporation" they should not be searched by case sensitive. How to do this. Convert the DB (23000 entries) or change some code.... Here is my "result" code: print "<table border=1>\n"; $query = "SELECT * FROM $table WHERE Field1 LIKE '%$icao%' $ton Field2 LIKE '%$name%' $ton2 Field3 LIKE '%$country%' ORDER BY $sort"; $result = mysql_query($query) or die("Error in query"); while($row = mysql_fetch_assoc($result)){ print "<tr>\n" ."<td>" . $row['Field1'] . "</td>\n" ."<td>" . $row['Field2'] . "</td>\n" ."<td>" . $row['Field3'] . "</td>\n" ; } Thanx, Jacco print "</tr></table>"; -- http://seabird.jmtech.ca Attitude is Everything! But Remember, Attitudes are Contagious! Is Yours worth Catching????