What is the value of cMyTableName? It should be an alias not a table name.

>I wanted to ask you if I use your suggestion correctly, since I am getting strange results.
>
>My SQL looks like this:
>
>

>SELECT * FROM (cMyTableName) ;
>	WITH (Buffering = .T.) ;
> 	WHERE MYFLD = cUserEntry ;
> 	TO SCREEN NOCONSOLE
>
>

>
>The strange results I get is if the table has 1 record and I add another record with the same entry, the code above does not catch it. If I add 3rd record with the same entry, then the code finds the duplicate record. Can you think of why I get these results?