c# - How to retrieve encrypted data from database irrespective of case? -

i want retrieve encrypted data database sql, irrespective of case inserted in database.i have data in database in encrypted form when retrieve data using different case gives me wrong or no data.

for ex:

i have inserted abc in database salt created value different abc.

now user wants search abc these values same have different salt.abc has different encrypted value,abc has different in database. how can value irrespective of salt created without problem of case sensitive.

i have no option available check case @ time of insertion in database.

note: salt created in application using c#.

is possible,if not is/are options?

should standardize field @ time of insertion toupper() or to lower()?