Convert Text to VarChar

Posted on By David Kittell 
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
Originally Posted on July 10, 2013
Last Updated on October 26, 2015
All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.
Code MSSQL

Related Posts

Regex Match

Posted on

IF OBJECT_ID(N’dbo.RegexMatch’) IS NOT NULL DROP FUNCTION dbo.RegexMatch GO CREATE FUNCTION dbo.RegexMatch ( @pattern VARCHAR(2000) ,@matchstring VARCHAR(MAX) –Varchar(8000) got SQL Server 2000 ) RETURNS INT /* The RegexMatch returns True or False, indicating if the regular expression matches (part of) the string. (It returns null if there is an error)….

Read More

INI DB

Posted on

<% ‘**************************************************************************** ‘* Terms Of Use * ‘**************************************************************************** ‘**************************************************************************** ‘* This script is provided free of charge by WebEarth Network. * ‘* http://www.web-earth.net * ‘* by all mean feel free to modify any or all content of this script, * ‘* feel free to do anything with it you wish,…

Read More