Data Comparison from the DB during Search?
Hi,
I have a search text box where i will key in the data
like "TigerWoods" where the data in the Database is like
"TIGerWooDs". So when i pass the name as a paremeter in the
DAO layer and send the parameter in a query to find the name. It is giving me no result since the name entered in the text box does not match with the data in the DB(with upper & lower case letters). Where the name is the same. where it should accept the name entered and give me the result like name found.
One thing is that i can't convert by name into uppercase or lowercase
letters in my application. Becos, the DB will have the name in any format (with both upper & lower case letters). How to solve this pbm. pls. do provide a soln. to this pbm. since this is quite urgent...
Thanks,
--JavaCrazyLover--
