SELECT * from prop_97 WHERE prop_numb = VAL("1065") * or (VAL("1065") is the same as 1065 in this case) SELECT * from prop_97 WHERE prop_numb = 1065would return the records with value 1065 in the prop_numb field.
SELECT * from prop_97 WHERE prop_numb = 10655 * and SELECT * from prop_97 WHERE ALLTRIM(STR(prop_numb)) == "10655"Would return the records with value 10655 in the prop_numb field.
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?