[SQL] Re: Search

2001-02-06 Thread PM
force lower case or use the non case-senstitive search e.g. lower(column) LIKE lower('%$suchbegriffe[$i]%') or column ~* '$suchbegriffe[$i]' (no need for wildcards when using ~* it assumes %value%) "Sebastian --[ www.flashhilfe.de ]--" <[EMAIL PROTECTED]> wrote in message 95n58g$5fa$[EMAIL P

Re: [SQL] Joining several tables

2001-01-24 Thread PM
As long as the contactid is not null in any of the tables its easy. You didn't give any column name information so I'll wing it. Not knowing the relationships between the tables means this might get you a fair amount of repeat data. If there is only ONE row in each table for a given contactid it'l