intermedia
From: Mary <marinag_at_yellowpages.co.il>
Date: 13 Dec 2001 05:44:58 -0800
Message-ID: <cc589430.0112130544.13fee555_at_posting.google.com>
Date: 13 Dec 2001 05:44:58 -0800
Message-ID: <cc589430.0112130544.13fee555_at_posting.google.com>
May I use "contains(**,**,1)>0" in the same query twice?
Like this:
select *
from
bus_customers_lang bcl
bus_cust_quest_lang bcql
where
contains(bcl.cust_site_keywords , 'bank',1)>0
or
contains(bcl.cust_description , 'bank',1)>0
or
(bcql.CUST_ID = bcl.cust_Id
and bcql.ANSWER_ID = 11
and contains(ANSWER_text , 'bank', 1) >0
)
Received on Thu Dec 13 2001 - 14:44:58 CET