| Text search [message #316371] |
Thu, 24 April 2008 16:55  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
