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

You guys are more knowledgeable and helpful than our own BMEU. You spared us from the $190 dollar fee and the BMEU told us that the mailing will be going out today. Thanks!
B.S., Jacksonville, FL