Hi Armin, Thank you very much for your help!
My goal is to have only one search form field, and use the value inserted there to do the search in two columns at the same time. That is, search the same value in both columns. For example, this table id | col1 | col2 1 | 2001 | 2005 2 | 2006 | 2008 3 | 2007 | 2011 4 | 2008 | 2013 ... I want to something like this query SELECT id, col_1, col2 FROM table WHERE col_1 ilike '%2008%' OR col_2 ilike '%2008%' ORDER BY col_1 to obtain this result id | col1 | col2 2 | 2006 | 2008 4 | 2008 | 2013 Do you think this is possible? Thanks! Best regards, Pedro ------------------------------------------------------------------------------ _______________________________________________ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
