ignoring case in select statement

Question

Dear Sir/Mam Can anyone tell me select statement for ignoring the case. For example I have entry Amarjit in table Names and i want to use select statement which takes name from a text box and shows the name even if the textbox contains all letters in small case or mixed case(e.g. amarjit amaRJIt). I want that the select statement should ignore the case while looking from the database table. Also Please tell me How can i search whole table for some particular keyword. Means if I have keyword abc how can i search if it exists in any row in any column in table and then how to select that column. Thanks in advance for your kind help.

Kirtan Patel · Answer

You Have to make all the cases same at data entry time in database u can use .ToUpper() or To.Lower() method to do this now while searching record u have to make the Search text To.Lower() or To.Upper() according to what method u used when you entered data into database .now if user enter text in any case it will be match in database because all case converted to database 's text format either it is lower case or upper case Hope This Will be Helpful Happy Coding :-)