Re: [Phpgroupware-developers] Re:Follow Up: Questions from New User/Developer

[Michael Dean]

Because the data stored in the server may not be completely lower case. 
You have to specify that you want to query against lower case in the SQL
statement.  This function should be part of the db abstraction.  I do
lowercase the string in code instead of sql, but you must always
lowercase the field in SQL.

On Fri, 2002-02-22 at 01:29, Luca - De Whiskey's - De Vitis wrote:
> On Fri, Feb 22, 2002 at 11:26:26AM +1100, Ashleigh Gordon wrote:
> > />Why not just do
> > >$sql .= " lower($f) LIKE lower('%$query%') OR ";
> > /
> 
> Even better (IMHO), why don't you use strtolower php function?
> In this case you do not need to know anything about the dbms (more portable).
-- 
Michael L. Dean
Double Choco Latte - http://dcl.sourceforge.net/
GNU Enterprise     - http://www.gnuenterprise.org/