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..
Printable View
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..
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).