At 02:11 +0300 on 25/07/1999, tjk(at)tksoft(dot)com wrote:
> You could merge the fields and search with :
>
> select * from tablex where lower(f1||f2||f3) ~ 'foo';
Nah. If f1 is 'Narf' and f2 is 'oodp', it will match...
Herouth
--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma