>Sometimes the following does not return any data for me:
>
>CREATE TABLE MyTable (MyField C(10))
>APPEND BLANK
>REPLACE MyField WITH "TEST"
>SELECT * FROM MyTable WHERE MyField = "TEST"
>
>Any ideas why this sometimes fails to return anything?
>Note: If I Issue a GO RecNo() just after the REPLACE command, it works. But in my application MyTable is a huge File and I aam worried this will reduce performance if I Have to issue a GO RecNo() After every replace.

I doubt that a GO RECNO() will have much impact at all. But I have to admit, I've been surprised before.

I take it that your code here is a 'representation' of the code that you believe to be relevant.
Do you have row buffering in effect? Is there a Grid involved with the table? Do you do any datasession switching in the real stuff?

good luck