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

selectid from table wherecontains (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' becausecontains 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,'&','') , ' %att%' 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: Sat Apr 19 01:23:28 CDT 2014

Total time taken to generate the page: 0.12688 seconds