A Wild guess here .. No way for me to test it..
select * from mytable
where contains(a_text,'\@msn.com') > 0 Escape '\'
--
Cheers,
Ganesh Raja
"Cookie Monster" <cookie.monster_at_somewhere.com> wrote in message
news:c29fj6$1pqikj$1_at_ID-82797.news.uni-berlin.de...
> Hi,
>
> I am using Oracle 9i Text and I have the below query statement which
returns
> the wrong results:
>
> select * from mytable
> where contains(a_text,'@msn.com') > 0
>
> The problem is this returns ALL documents with msn.com and not the
documents
> containing only '@msn.com' basically the @ is ignored. I just want to find
> the email addresses. Does anyone know how I can force a search for this
> query and get oracle text to use the @ ?? I tried escaping the character
and
> everything but this no affect on the results.
>
> Thanks,
> Cookie.
>
>
Received on Fri Mar 05 2004 - 03:28:06 CST
