How to embed a hyperlink into Data Link SQL command

Hi,

I have the following command in a Data Link

SELECT PID as [PID Number]

, DPAREA1 as [DP Area (1)]

, DPAREA2 as [DP Area (2)]

, DPAREA3 as [DP Area (3)]

, ALR

, FLOODPLN as [Flood Plain]

,Zoning as [Zoning]

, CONCAT(CONCAT('https://gis.mycity.ca/Utilities/ZoningPDF/', ZONING), '.pdf') as [Zoning PDF]

FROM ZONING WHERE PID = 1

I would prefer that Zoning PDF column doesn't show a full URL but rather appears as a hyperlink for Zoning.

How to format the Command in this case to embed a hyperlink into Data Link SQL command ?

thanks

Commentaires