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!
Jim Philippi
quando omni flunkus moritati