Convert Text to VarChar

CONVERT(varchar(8000),col1)

Example: IP is varchar(50) and Hostname is Text

Not sure why you would ever have a need for this but this is an example that works.

SELECT id
	,DATETIME
	,('IP Address:' + ipaddress) AS "IP Address"
	,('Hostname: ' + CONVERT(VARCHAR(8000), hostname)) AS "Hostname"
FROM pageview

More practical use

SELECT id
	,DATETIME
	,(ipaddress + ' | ' + CONVERT(VARCHAR(8000), hostname)) AS "IP Address"
FROM pageview