>>Have you tried SELECT * FROM MYTABLE WHERE CTITLE=CNAME INTO CURSOR TEMP?
>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?
You may try this
SELECT * FROM MYTABLE WHERE CNAME$CTITLE INTO CURSOR TEMP
However, for fuzzy searching, I strongly recommand PHDBase.