select T1."KONTO_NR" as "Konto Nr", T1."KONTO_BEZEICHNUNG" as "Konto Bezeichnung", T1."KONTO_ART" as "Konto Art_ori", T1."KOSTENSTELLE" as "Kostenstelle", T1."STK" as "Stk", T1."KONTO_1" as "Konto 1", T1."KONTO_2" as "Konto 2", T1."KONTO_3" as "Konto 3", T1."KONTO_4" as "Konto 4", T1."KONTO_5" as "Konto 5", T1."EBENE1" as "Ebene1", T1."EBENE2" as "Ebene2", T1."EBENE3" as "Ebene3", T1."EBENE4" as "Ebene4", T1."EBENE5" as "Ebene5", T1."EBENE6" as "Ebene6", T1."EBENE7" as "Ebene7", T1."EBENE8" as "Ebene8", T1."EBENE9" as "Ebene9", T1."EBENE10" as "Ebene10", T1."EBENE11" as "Ebene11", T1."EBENE12" as "Ebene12", T1."EBENE13" as "Ebene13", T1."EBENE14" as "Ebene14", T1."EBENE15" as "Ebene15", T1."EBENE16" as "Ebene16", T1."EBENE17" as "Ebene17", T1."EBENE18" as "Ebene18", T1."EBENE19" as "Ebene19", T1."EBENE20" as "Ebene20", T1."EBENE21" as "Ebene21", T1."EBENE22" as "Ebene22", T1."EBENE23" as "Ebene23", T1."EBENE24" as "Ebene24", T1."EBENE25" as "Ebene25", T1."EBENE26" as "Ebene26", T1."EBENE27" as "Ebene27", T1."EBENE28" as "Ebene28", T1."EBENE29" as "Ebene29", T1."EBENE30" as "Ebene30", T1."EBENE31" as "Ebene31", T1."EBENE32" as "Ebene32", T1."EBENE33" as "Ebene33", T1."EBENE34" as "Ebene34", T1."EBENE35" as "Ebene35", T1."EBENE36" as "Ebene36", T1."EBENE37" as "Ebene37", T1."EBENE38" as "Ebene38", T1."EBENE39" as "Ebene39", T1."EBENE40" as "Ebene40", T1."EBENE41" as "Ebene41", T1."EBENE42" as "Ebene42", T1."EBENE43" as "Ebene43", T1."EBENE44" as "Ebene44", T1."EBENE45" as "Ebene45", T1."EBENE46" as "Ebene46", T1."EBENE47" as "Ebene47", T1."EBENE48" as "Ebene48", T1."EBENE49" as "Ebene49", T1."EBENE50" as "Ebene50", T1."EBENE51" as "Ebene51", T1."EBENE52" as "Ebene52", T1."EBENE53" as "Ebene53", T1."EBENE54" as "Ebene54", T1."EBENE55" as "Ebene55", T1."EBENE56" as "Ebene56", T1."EBENE57" as "Ebene57", T1."EBENE58" as "Ebene58", T1."EBENE59" as "Ebene59", T1."EBENE60" as "Ebene60", T1."EBENE61" as "Ebene61", T1."EBENE62" as "Ebene62", T1."EBENE63" as "Ebene63", T1."EBENE64" as "Ebene64", T1."EBENE65" as "Ebene65", T1."EBENE66" as "Ebene66", T1."EBENE67" as "Ebene67", T1."EBENE68" as "Ebene68", T1."EBENE69" as "Ebene69", T1."EBENE70" as "Ebene70", T1."EBENE71" as "Ebene71", T1."EBENE72" as "Ebene72", T1."EBENE73" as "Ebene73", T1."EBENE74" as "Ebene74", T1."EBENE75" as "Ebene75", T1."EBENE76" as "Ebene76", T1."EBENE77" as "Ebene77", T1."EBENE78" as "Ebene78", T1."EBENE79" as "Ebene79", T1."EBENE80" as "Ebene80", T1."EBENE81" as "Ebene81", T1."EBENE82" as "Ebene82", T1."EBENE83" as "Ebene83", T1."EBENE84" as "Ebene84", T1."EBENE85" as "Ebene85", T1."EBENE86" as "Ebene86", T1."EBENE87" as "Ebene87", T1."EBENE88" as "Ebene88", T1."EBENE89" as "Ebene89", T1."EBENE90" as "Ebene90", (len(T1."KONTO_NR" + 'Z') - 1) as "Anzahl Stellen_Konto_Nr", T1."KONTO_ART" as "Konto Art", T1."KONTO_ART" as "GuV_Bilanz", T1."KONTO_NR" as "Acct Nr", T1."KONTO_NR" + ' - ' + T1."KONTO_BEZEICHNUNG" as "Konto", (left(T1."KONTO_NR",1)) as "Susa" from "Kontenrahmen.csv" T1 where (((left(T1."KONTO_NR",1))) <> '9')