View Single Post
  #1   Report Post  
Manu
 
Posts: n/a
Default Removing the +4 from zip+4

Column contains 10 characters (e.g. 02453-1234) making up the zip+4. I need
to remove the last 5 characters, leaving only the basic 5 digit zip-code.
The column contains about 10,000 entries. Please suggest methods by which
this can be done. Thanks!