Support 805.461.7300
Sales
Our Technology. Your Success.

Add NDC field and data to your database

If you want to add an NDC field to your database and populate it with the 3 digit NDC ZIP based on your 5-digit ZIP Code, then open your database, pull down the Edit menu to Command, and run this command:

* Suppress Messages 
ON ERROR com_Mesg=MESSAGE() 

* Add NDC column
ALTER TABLE (ALIAS()) ADD COLUMN ndc(3) 

* Add NDC number 
REPLACE ALL ndc WITH substr(GetLineValue(ADDBS(xDefFldr)+"iPresort\DMM\AZL601.txt",INT(VAL(LEFT(zip,3))),67,.T.,.T.),9,3)

« Back to Commands

I want you to know that Christine has gone above and beyond to help me fix the problem. She has extraordinary customer service skills. She is a great asset to AccuZIP and their customers
R.K., Germantown, MD