note 15844 added to function.sql-regcase

Better solution would be to convert the SQL column to all upper-case or lower case while inserting the data, once that's done, you can compare simply by saying: where field_name LIKE upper('%pattern%') As someone noted, this solution will keep the index intact because the upper function is performed on the variable rather then the SQL Column.. -- http://www.php.net/manual/en/function.sql-regcase.php http://master.php.net/manage/user-notes.php?action=edit+15844 http://master.php.net/manage/user-notes.php?action=delete+15844 http://master.php.net/manage/user-notes.php?action=reject+15844