select p.PARPARROLLEID_PARTNER as PARID, pn.NAME as PNAME, num.monnum as N, SUBSTR(pn.NAME,num.monnum,1) as CHAR_N, ASCII(SUBSTR(pn.NAME,num.monnum,1)) as CODE_N, DUMP(pn.NAME,16,num.monnum,1) as DUMP_N
 from BEPARTNER p
   left outer join BS_PNAME pn on pn.PARID=p.PARPARROLLEID_PARTNER
     left outer join (select cal.MONAT as monnum from CCCAL cal where cal.JAHR=2013) num on 1=1
 where PARPARROLLEID_PARTNER=11497380