Add County Information to Simplified Lists

`ON ERROR com_message=message()` `SET SAFETY OFF` `ALTER TABLE (alias()) ADD COLUMN countynm_ C(30)` `ALTER TABLE (alias()) ADD COLUMN countyno_ C(3)` `USE (ADDBS(xDefFldr)+"DMM\_uszips.dbf") IN 0 ALIAS _uszips ORDER USZIP` `REPLACE countynm_ WITH _uszips.countynm FOR SEEK(LEFT(zip,5),"_uszips")` `REPLACE countyno_ WITH _uszips.countyno FOR SEEK(LEFT(zip,5),"_uszips")` `USE IN (SELECT("_uszips"))`

ON ERROR com_message=message()

SET SAFETY OFF

ALTER TABLE (alias()) ADD COLUMN countynm_ C(30)

ALTER TABLE (alias()) ADD COLUMN countyno_ C(3)

USE (ADDBS(xDefFldr)+"DMM\_uszips.dbf") IN 0 ALIAS _uszips ORDER USZIP

REPLACE countynm_ WITH _uszips.countynm FOR SEEK(LEFT(zip,5),"_uszips")

REPLACE countyno_ WITH _uszips.countyno FOR SEEK(LEFT(zip,5),"_uszips")

USE IN (SELECT("_uszips"))

« Back to Commands

New to the
Mailing
Industry?
More Info

Professional Services
More Info

I wanted to take a minute to write accolades for your employee Eric Lambeth. I have been calling on Eric for training and help in the Accuzip software since May and I want you to know that from a client standpoint, he is second to none! Eric has gone way above and beyond in helping me learn and navigate your software as well as helping us through some crazy situations we have encountered. It is clearly evident that he knows this software inside and out. It is also evident that Eric loves the customer and is willing to do whatever it takes to help – he has even answered emails and called me on the weekend to help through some stuff I was unsure of! I cannot express enough how wonderful Eric has been for our organization. I will tell you that I came to this organization with a background in BCC software with plans to transition to BCC software. Eric’s knowledge, guidance, training, and willingness to help at all hours of the day/week has sold me on Accuzip! Your software solution is more user friendly and the support staff far exceeds BCC! I am also looking forward to investigating your other software solutions.

S.M., Elmhurst, IL