Cookie Monster wrote:
> 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.
>

try

chr(64) || 'msn.com'

as an alternative.