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!
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.