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 have the best tech. support in the business.
R.H., Napels, FL