I am trying to make the search case insensitive
query += "@Name='" + frmMain.txtName.value + "'";
I modified the code as below
query += "translate(@Name,'ABC','abc')='" + frmMain.txtName.value.toLower() + "'";
it does not seem to work.
what i am missing in the above code
any help would be appreciated.