Hi All:

I am trying to select a record that matches a particular number from Table AA. I have the following code:

mFindRefNumber = 2111

SELECT * from AA INTO CURSOR BBQ NOFILTER,;
 WHERE AA.Number = mFindRefNumber

When this statement is executed, 0 records are selected from Table AA. And I know for sure that the field Number in Table AA has the value stored in mFindRefNumber.

Where am I going wrong? Thanks.