Convert $#@ to ÅÄÖ and }{| to åäö

If swedish characters are saved in strange format in DB2, propably due to wrong ebcdic/asscii conversion, use DB2 command "Translate" as in below example:


Select USERID, ORG_UNIT, COMPANY,
       Translate(GIVEN_NAME,'åäöÅÄÖé', '}{¦$#@`') AS GIVEN_NAME,
       Translate(MIDDLE_NAME,'åäöÅÄÖé', '}{¦$#@`') AS MIDDLE_NAME,
       Translate(SURNAME,'åäöÅÄÖé', '}{¦$#@`') AS SURNAME,
       EMPL_NO, EMPL_START, EMPL_END, EMPL_TYPE, COST_CENTER, DEPARTMENT, OFFICE,
       Translate(CITY,'åäöÅÄÖé', '}{¦$#@`') AS CITY,
       Translate(STATE,'åäöÅÄÖé', '}{¦$#@`') AS STATE,
       TELE_NO, MOBILE,
       Translate(CONS_COMPANY,'åäöÅÄÖé', '}{¦$#@`') AS CONS_COMPANY,
       EXT_UID
from DB2TableName
whereTranslate(CITY,'åäöÅÄÖé', '}{¦$#@`') = 'Göteborg'