ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 15F34F6D1027D323E06362FB0905F9B2Y select hp.party_number, 'HYPERLINK("'||case when hp.url like 'http%' then null else 'https://' end||hp.url||'","'||replace(hp.party_name,'"','""')||'")' party_name, hp.party_type from hz_parties hp where hp.url is not null US Hyperlink test