SELECT * from prop_97 WHERE prop_numb = 10655is the simplest expression. What does that return?
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?