Hi all,
In DataBase, first names and last names etc are entered in any fashion (lower, upper or any combination of these). I need to look for records based on first name or last name (search). There is no other field for search.
In my case, he will search in the DB with CAPs as input. But if it exactly matches, then only rec is picked from DB. I need to get those records without comparing upper and lowercases.
Thanks,
Santosh