Hi,

I have a edit box on a form. User types in information and then clicks a search button. code looks like this:

lcSql = "select * from table where upper(fieldname) like '%" + UPPER(lcDescrip) + "%' into cursor myCursor"
&lcSql

IF the user presses the "enter" key in the edit box we get an error message, critical error 36. I think the problem is that foxpro doesn't like the upper function and the return key. Only problem is that I want this to be a case insensitive search. Any ideas on how to fix this?

Using VFP 7, sp1

Thanks!