> select first_name from member where (home_email1 like V) AND
>(home_email2 like '%tvk%')
Sorry; cut and pasted that wrong. I meant:
select first_name from member where (home_email1 like '%tvk%') AND
home_email2 like '%tvk%')
- Darryl
> select first_name from member where (home_email1 && home_email2)
>like '%tvk%';
I think this needs to be something like:
select first_name from member where (home_email1 like V) AND (home_email2
like '%tvk%')
- Darryl
Try,
select first_name from member where home_email1 like '%tvk%' and home_email2
like '%tvk%';
Best regards,
Andrew
Andrew Hill
Director Technology Evangelism
OpenLink Software
http://www.openlinksw.com
XML & E-Business Infrastructure Technol