Hi Bret!

Actually these two statements get the same results. Both return the same three records.

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

Note the "=="

What I have a problem with is that

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

gets zero records and

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

gets three records. What's the difference?