ON ERROR com_Mesg=MESSAGE()
SET SAFETY OFF
ALTER TABLE ALIAS() ADD COLUMN errno_desc C(30)
Replace all errno_desc with "State Not Found" FOR "1.1" $ LEFT(errno_,3)
Replace all errno_desc with "City not found " FOR "2.1" $ LEFT(errno_,3)
Replace all errno_desc with "Street not found " FOR "3.1" $ LEFT(errno_,3)
Replace all errno_desc with "Address not found" FOR "4.1" $ LEFT(errno_,3)
Replace all errno_desc with "+4 unavailable" FOR "5.1" $ LEFT(errno_,3)
Replace all errno_desc with "Multiple streets match" FOR "6.1" $ LEFT(errno_,3)
Replace all errno_desc with "Multiple addresses match" FOR "6.2" $ LEFT(errno_,3)
Replace all errno_desc with "Cardinal Rule multiple match" FOR "6.3" $ LEFT(errno_,3)
Replace all errno_desc with "Address not found in DPV Database" FOR "N N" $ LEFT(dpv_,3)
|
