hi ...i'm using oracle's soundex function in my sql query , but the problem is that sometimes it works fine but sometimes it returns rows which i dont want ..and there is no excat
pattern matching...of words..
for eg if i search for "vasant vihar" it gives me all the words starting with "v" but ideally it should giv only terms related with "vasant"
i want to use more refined search..
pls hurry up folks!!