Thank you!

>Use following logical expression to find such records:
>allt(str(val(HouseNumber),12,0)) == allt(HouseNumber)
>Expression will be .T. when HouseNumber is really number, .F. when it contains some other characters.
>
>>I have acquired table with an address number (in a character) field that I want to clean up. Got just about everything taken care of but there are some records that are like "1234B". I tried to exclude them with val( HouseNumber) but it simply returns 1234. What’s the best way to find these sorts of records to remove them programmatically? Thanks!