who knows other form???? its a script in Perl, this script search in my db, but if the client put "Perl", the matches its diferent whit "perl". One form its substutions upper/lower in the script of perl, but i dont like very much. Anyone??? Thanks On Fri, 17 Mar 2000, Mini-Me wrote: > use > > select * from books where titulo ~* perl or Perl or PERL > > it returns a regex expression. > > angel > > At 04:35 PM 3/17/00 -0600, you wrote: > > > >select * from books where titulo like '%perl%'; > > > >select * from books where titulo like '%Perl%'; > > > > > >in This querys, postgres return diferents registers, but i need return > >the same registers... what i doing? > > > >regards. > >jcmd >