Home » Server Options » Text & interMedia » Text search (10G)
Text search [message #316371] Thu, 24 April 2008 16:55 Go to next message
jimbo021956
Messages: 5
Registered: October 2007
Junior Member
Concerning the following text search:

select * from catalog where
contains(callnum,'#00000%') > 0;

It seems that ORACLE is ignoring the number sign (#) and giving
me all call numbers that begin with 5 zeros and not
beginning with a number sign. Is this true and is there
a way around it so that ORACLE will recognize the leading
number sign within the search criteria?

Thanks for your help
Re: Text search [message #316373 is a reply to message #316371] Thu, 24 April 2008 17:06 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You may want to check Indexing Special Characters.
Previous Topic: Source of the hit on a concatenated datastore?
Next Topic: Re: DRG-51030: wildcard query expansion resulted in too many terms
Goto Forum:
  


Current Time: Thu Mar 28 16:36:59 CDT 2024