RADE_HNNR_HNTC_HN
tc+UPPER(SUBSTR(trade,1,10))
"HN-"$db
0504HARDWARE, 
1601GER
TE, ZU
2003BEVANDE AL
3100INVESTIGAC
3901TYRE DEALE
SMO, VRAVEL AGET OFTOURISME,FREMDENVER106AGENZIE DIWINE BEER2003BOISSONS A
TE, ZUEQUIPO Y A601APPARECCHITREAWATER PURIUMWELTSCHUZIONETIONPROTECCION403ENVIRONMENCAHIPPING (SCHIFFAHRTMARITIMA (CANTIERI N102AFFAIRES MTRACTORSQUINARIAMACHINES,LANDWIRTSCULTUR1001AGRICOLTURVERLAGEPUBLISHERSMAISONS D'INTERNATIOALE801EDITORITRADING CORAPPRESENTMANUFACTURHANDELSGESENTREPRISE604COMPA
IAS0504INFORMATIQ
,HARDWARE -EDV, HARD-S,PER D504COMPUTACIOWINDOWS &UERTAS YPORTES, FEINESTRE,FENSTER, T11DOORS AND
BEL, EINOBILIARIOMEUBLES, AFURNITURE404ARREDAMENTSEINDUSTRIAGIFTS-MANUSCHE308CHEMICAL ARKZEUGE,WELDING EQUTENSILI,TOOLS, INSPLUMBING FOUTILS, IN207HERRAMIENTSUPPLTILE MANUFUX,IMATERIAL DUILDING M0109BAUSTOFFE,
VANDE ALBEBIDAS ALKOHOLISC3ALCOHOLICWATER-BOTTGETR
NKE (OISSONS (VERAGESBEBIDAS (G2001ACQUA MINE, PRETEODAMENSWEAR DFASHION8ALTA MODA,S (PRE MATEXTILBEDAPROCESO TE17LAVORAZIONPIELESPRLEATHER GOH
UTE, FELCUIRS ET P803ABBIGLIAMETOYS-WHOLEKUNST, KULS, CULTCULTE,  CUL700ART, CULTUVIDEO EQUIV, RADIOTELECOMMUN1601MATERIEL,
INVESTIGAC100FORSCHUNG,TOOLS-ELECFOURNITURETTRICITKTRONISELECTRONIC3006ACCESORIOSVENTE D'AUOMERCIANTCAR MARTS,OBILEERCAT6AUTOMARKT,TRUCK DEALFAHRZEUGBAOSTRUZIONROCERIACAROSSERIE804BODYWORK,TESTING ANSTATIONS DPR
F-, KONORGANI DIINSPECTION708ESTACIONESURISMO, VRAVEL AGET OFTOURISME,FREMDENVER106AGENZIE DIWINE BEER2003BOISSONS A
TYRE DEALEQUKSPNEUMATICA901NEUMATICOSWERKSBHANDICRAFTRAFTSMENCOMERCIANTZIENDE AR201ARTISANS,SURVEYORS-ICERCHE,SEARCH,3100RECHERCHE,
UPPER(SUBSTR(trade,1,40))
"HN-"$db
TESTING AND MONITORING STATIONS, CONSUME
WINE BEER SPIRITS-WHOLESALE & MANUFACTUR
ERAGES (GENERAL)VANDE ALCOLICHE,  LIQUORI,  SPIRITIALCOHOLICASEBIDAS (GENERAL)BAUSTOFFE, BAUTEILE, ZUBEH
RZIENDE ARTIGIANE,  LAVORAZIONE LEGNO,OBILE-RENTALSERCATO,  CONCESSIONARI,  NOLEGGIO,UTOMARKT, -HANDEL, -VERTRETUNG, -VERMIES, CULTURE, FORMATION, MUSIQUE, LOISIISANS, FOURNISSEURSCULTURA, EDUCACION, MUSICA, ENTRETE,  CULTURA,  ISTRUZIONE,  MUSICA,  PART, CULTURE, MUSIC, ENTERTAINMENT, EDUC
RREDAMENTO,  PRODUZIONE,  VENDITA,  MOBPPARECCHI E ACCESSORI,  PRODUZIONE,  VETA MODA,  STILISTI,  ABITI DA SERA E DKOHOLISCHE GETR
NKELCOHOLIC BEVERAGESULTURAL MACHINERY AND ACCESSORIESRICOLTURA - MACCHINE,  ATTREZZI,  PRODGENZIE DI VIAGGIO,  PROMOZIONE ATTIVITAFFAIRES MARITIMES (CHANTIERS DE CONSTRUQUA MINERALE,  INDUSTRIE,  PRODUZIONECCESORIOS ELECTRICOSABBIGLIAMENTO IN PELLE,  LAVORAZIONE PEL
IAS DE COMERCIO, ASOCIACIONES Y RE, REPRESENTACION DE COCHES (OMERCIANTES Y ARTESANOSSCHE INDUSTRIE, ERZEUGNISSE, CHEMIEHEMICAL AND PHARMACEUTICAL INDUSTRY ANDROCERIA, ACCESORIOS, PIEZAS DE RECAMBOSSERIES, ACCESSOIRES, PIECES DETACHER MARTS, CAR DEALERS, -REPRESENTATION,CANTIERI NAVALI,  PORTI MARITTIMI,  FLUVUILDING MATERIALS, COMPONENTS AND ACCESALCOOLISEESISSONS (DIVERS)BODYWORK, ACCESSORIES, SPARE PARTS (CARS
\``x\
QUIPO Y ACCESORIOSVIRONMENTAL PROTECTIONNTREPRISES ET SOCIETES COMMERCIALES, RETTRICITA',  ACCESSORI ELETTRICI,  MATKTRONISCHES ZUBEH
RLECTRONIC ACCESSORIESV, HARD- UND SOFTWARE, SERVICEALESEDITORIDOORS AND WINDOWSUIRS ET PEAUXRAFTSMEN AND TRADESMENSTRUZIONE MOTORI,  PEZZI DI RICAMBIO,S, DATA PROCESSING, HARD- AND SOPARTS & SUPPLIESER DEALERSCOMPUTACION, PROCESO DE DATOS, SERVICO H
WERKSBETRIEBEICRAFTSHANDELSGESELLSCHAFTEN, -VEREINIGUNGEN, -IFTS-MANUFACTURERS, RETAIL & WHOLESALETR
NKE (ALLGEMEIN)GER
TE, ZUBEH
RAND ACCESSORIESURNITURE - WHOLESALERS & MANUFACTURERSREMDENVERKEHR, REISENURNITURES ET ACCESSOIRES ELECTRONIQUESORSCHUNG, WISSENSCHAFT, MEDIZININESTRE,  PORTE,  SERRAMENTI,  PRODUZIOENSTER, T
RENSHIONFAHRZEUGBAU, ZUBEH
R, ERSATZTEILEESTACIONES DE CONTROL Y VERIFICACION, AG
KUNST, KULTUR, MUSIK, UNTERHALTUNG, BILDVESTIGACION, CIENCIA, MEDICINATERNATIONAL TELECOM AND TRADE DIRECTORSPECTION & TESTING SERVICESFORMATIQUE-ORDINATEURS, TRAITEMENT DES CHIMIQUES, MATIERES DE BASE,E E PRODOTTI CHIMICI-FARMACEUTICINDUSTRIA QUIMICA Y FARMACEUTICA, PRODUC
UTE, FELLEERRAMIENTAS, INSTRUMENTOS, ACCESORIOS,,  SOFTWARE,  ELABORAZIONE DATI,WHOLESALE & MANUFACTURERSHARDWARE - RETAIL
EL, ACCESSOIRESUX, FOURNITURES DE CONSTRUCTION,I EDILI,  PARTI EDILI ED ACCESSOTERIAL DE CONSTRUCCION, COMPONENTES YRITIMA (ASTILLEROS, PUERTOS, LINEAS MAQUINARIA AGRICOLA Y ACCESORIOSNUFACTURERS AGENTS & REPRESENTATIVESISONS D'EDITIONSMACHINES, APPAREILLAGES AGRICOLESPRODUCTS, SKINS AND HIDES, FEATHEATHER GOODS - WHOLESALE & MANUFACTURERVORAZIONE PRODOTTI TESSILI,  CONFEZIONLANDWIRTSCHAFTLICHE GER
TE, ZUBEH
&$!P4+
na,GnQ@
ZIONE DELL'AMBIENTETION DE L'ENVIRONNEMENTTECCION AMBIENTALROCESO TEXTILORTES, FENETRESQUESKSNEUMATICA,  OLEODINAMICALUMBING FIXTURES & SUPPLIESPIELESUTILS, INSTRUMENTS, APPAREILLAGE, ACCESORGANI DI ESAME,  TUTELA E PROTEZIONE DENEUMATICOS
BEL, EINRICHTUNGEN, ZUBEH
R, PRET-A-PORTEREDAOBILIARIOS Y ACCESORIOSUBLES, ACCESSOIRESMENSWEAR DISTRIBUTORS, WHOLESALERS & MAN
x7q!X
STING AND MONITORING STATIONS, CONSUMETELECOMMUNICATIONS EQUIPMENT & SERVICESURVEYORS-MARINETATIONS DE CONTROL (DE MESURE, DE REGULCOMPANIESAGENTSHIPPING (SHIPYARDS, PORTS, SHIPPING LINSCHIFFAHRT (WERFTEN, H
FEN, REEDEREIEN),ICERCHE,  SCIENZA,  MEDICINASEARCH, SCIENCE, MEDICINEECHERCHE, SCIENCE, MEDECINERAPPRESENTANZE COMMERCIALI,  SOCIETA' COERTAS Y VENTANASUBLISHERSPR
F-, KONTROLL-, SCHUTZSTELLEN
UMWELTSCHUTZYRE DEALERSV, RADIO EQUIPMENT AND ACCESSORIESURISMO, VIAJESUCK DEALER & PARTS SUPPLIERS & BUREAUSVEL AGENCIESDING COMPANIES, TRADE ASSOCIATIONS ANRACTORSYS-WHOLESALE & MANUFACTURERST OFFICESURISME, VOYAGES-ELECTRICOOLS, INSTRUMENTS, ACCESSORIES, FITTINGSUPPLIERSILE MANUFACTURERSS (FABRICATION)PROCESSINGE MANUFACTURERSTEXTILBEDARF, TEXTILVERARBEITUNG
E BEER SPIRITS-WHOLESALE & MANUFACTURINDOWS & WINDOW FRAMESRKZEUGE, INSTRUMENTE, ARMATUREN, ZUBEHELDING EQUIPMENT & SUPPLIES-BOTTLED & BULKTREATMENT EQUIPMENT SERVICE & SUPPWATER PURIFICATION, FILTRATION & PROCESSIDEO EQUIPMENT & RECORDERSRLAGEVENTE D'AUTOMOBILES, CONCESSIONNAIRES, LUTENSILI,  STRUMENTI DI PRECISIONE,  ACC
UMWELTSCHUTZ                            
WINE BEER SPIRITS-WHOLESALE & MANUFACTUR
ARREDAMENTO,  PRODUZIONE,  VENDITA,  MOB
BEVERAGES (GENERAL)                     
COMPA
IAS DE COMERCIO, ASOCIACIONES Y RE
EQUIPO Y ACCESORIOS                     
HANDWERKSBETRIEBE                       
KUNST, KULTUR, MUSIK, UNTERHALTUNG, BILD
MATERIEL, ACCESSOIRES                   
PROTEZIONE DELL'AMBIENTE                
TESTING AND MONITORING STATIONS, CONSUME
"HN-"$db
0011645
0049581
8149575282120002269129138858477514851977434909869601574026885973592834682122014430250012304
1164590120110030066804708106320018178037006014031021001801604504114043082070000109