---

CASE
    WHEN chat_idx IS NOT NULL
         AND trim(chat_idx) <> ''
    THEN '<a href="https://portal.futurenpf.ru/online/?IM_DIALOG='
         || chat_idx
         || '" target="_blank">'
         || chat_idx
         || '</a>'
    ELSE ''
END