Search on phonenos
I need to search on number against the fields phone no , alternate phone no and mobile no . I have full text index applied on all the three columns .
While searching for a number 280010 , if the field contains the data in following format
1.80-288010
The row is fetched and displayed since it checks for a word
2.80288010
No result fetched since full text search is on a word
Please suggest a solution
Subject
Views
Written By
Posted
Search on phonenos
3006
September 01, 2005 11:22PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.