Home » Server Options » Text & interMedia » How to use & in contains keyword in context index
How to use & in contains keyword in context index [message #76114] Fri, 27 August 2004 09:11 Go to next message
renjith
Messages: 5
Registered: November 2001
Junior Member
Hi,

How to use ampersand ( &) in contains keyword.
I want to use

select id from table where   contains (company_name , ' %at&t%' or '%aol%') > 0 ;

Currently i am getting no records which is like at&t.

If i dont use % on both sides, i am getting records matching for 'at' and anything starting with 't' because contains is interpreting & as a special character.

Can anybody help me. I want records matching only for 'at&t'

 Thanks in advance

Renjith

 

 

 
Re: How to use & in contains keyword in context index [message #76145 is a reply to message #76114] Sun, 28 November 2004 09:05 Go to previous message
Just John
Messages: 69
Registered: November 2004
Member
You may (will) get a performacnce hit (how bad is the question!)

decode the & in the query.

contains(REPLACE(company_name,'&','¬') , ' %at¬t%' or '%aol%') > 0 ;

worth a shot!
Previous Topic: How do we find & replace a certain value in the database without even knowing th
Next Topic: Multiple options in Check Constraint
Goto Forum:
  


Current Time: Fri Mar 29 07:49:14 CDT 2024