Jim --

SELECT * from prop_97 WHERE prop_numb = 10655

is the simplest expression. What does that return?

But, in any case, 2 and 3 should return the same records.

I'd try a REINDEX.

Jay


>I’ve got a form used to search for an address. In table Prop_97 I have a n(5) field named prop_numb. There are records that contain the number 10655. If I do:
>

SELECT * from prop_97 WHERE prop_numb = VAL("1065")

>I get three records with this value. If I do:
>

SELECT * from prop_97 WHERE prop_numb = VAL("10655")

>I get no records. However if I do:
>

SELECT * from prop_97 WHERE ALLTRIM(STR(prop_numb)) == ("10655")

>I get two records. Is there something fundamental I’m doing wrong in the second statement? Why don't I get any results?
>
>Thanks!