Is it possible to create a hyperlink column in a SQL Server table? I was hoping to create a column which appears as Y but links through to a website like a normal hyperlink.
I created a test table as follows:
CREATE TABLE Test
I then tried to use HTML code within an INSERT INTO statement to add the hyperlink.
INSERT INTO Test (Hyperlink)
However, this actually creates a text output as specified above.
Is there a way for the output in the table to appear as Y but with an active hyperlink that feeds through to a specified URL?
Thanks in advance