Skip to Content
0
Former Member
May 15, 2008 at 07:10 PM

Search by names

50 Views

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