Thanks, Its good good good, my backend is PostgreSQL and the ILIKE is case insensitive by default !
On Feb 28, 9:11 pm, DenesL <[email protected]> wrote: > This depends on the DB backend, for example MSSQL is case insensitive > by default but there are several techniques to make it case > sensitive:http://vyaskn.tripod.com/case_sensitive_search_in_sql_server.htm > > On Feb 28, 12:45 pm, Alexandre Strzelewicz > > > > > > > > <[email protected]> wrote: > > Can we do an insensitive case query select with web2py ? > > > Thanks

