non-numerich chars in a field

[Lafor]

Would some one advise?

I would like to be able to pick only the rows where the
zip codes in a given database table contain non-numeric characters

Thanks a lot..

[AdrianH]

Try this.

Assuming your Zip Code field is called "Zip"

Generate a recordset based on the following SQL call.

SQLStatement = "Select [Zip] from [Table] where IsNumeric([Zip]) = False

The above assumes that you are using an Access DB

Regards

Adrian
VB6sp4, Delphi 4 (learning).