soundex problem

[sumit malik]

hi ...i'm using oracle's soundex function in my sql query , but it's not solving my purpose .I want to make my search more refined.
for eg if i search for "vasant vihar" it gives most of 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!!

[Desai Sandeep]

Will get back to you on this.
-- Sandeep

[Nguyen Trung]

Hi,
In pure sql, the query should be specified as the following:
select column_to_get
from your_table
where lower(column_to_search) like '%vasant%'
Try to pass this to Oracle server from your java program
regards,