I want to place a query to get all rows which matches the input string with specified column for this i want to do a compare on lower case how it is possible.
if employeename is a column in a table , i want to find all employees with name= "xyz" so i want to do a comparison in name and also both sides should be in lowercase.
datarow.select("LOWER(employeename) = " + name.ToLower().Trim())
the above is invalid, how can i achieve the above result.
Thanks & Regards