Filter records with alphabetic characters
570672Jun 11 2007 — edited Jun 11 2007I have a table with a zip code column. This table has US zip codes(only 5 digit numeric values) & Canadian postal codes (6 digit alphanumeric values). I would like to filter out all the Canadian postal codes and then create a table out of it. How would I go about doing it? Your advise would be much appreciated.