>>SELECT *FROM mytable WHERE mytable.ctitle LIKE '%'+cname+'%' into cursor temp.
>>This always creates a cursor with 0 records. The same code executed outside of the form from a .prg works fine. Could someone please tell me how to get it to work?
>
>Is cursor temp already taken in your form?
>
>You don't have a space after *.
>
>Have you tried SELECT * FROM MYTABLE WHERE CTITLE=CNAME INTO CURSOR TEMP?

Forgive me if this is a repeat, I didn't see my last reply...

I have not used cursor temp anywhere in the form.

What I'm trying to do is retrieve all records that match a word. If the user enters 'John', and the ctitle looks something like 'this is test data
(sybil,john,sue)' it should put it in the cursor. Thats the reason I'm using '%'+cname+'%'. % is a wild card, yes? This works great outside of the form from a .prg but doesn't from the page. Is this a bug?