We are using eVB & DB2e for developing a DB appln for Pocket PC. Dunno why but LCase if used in query in eVB code doesnt work and gives SQL error.

Basically we are making a search utility. But are not able to provide CASE INSENSITIVE search. SQL function "LCase" if worked could have solved the problem. But it gives error when used in eVB.

Is there any solution for providing CASE INSENSITIVE search. Some kind of WORK AROUND ????