HTML codes

Below is a good resource if you need to re-build information from a databaase and parse it into an http:// website address
(hint-hint.. namely Reporting Services links too!)

DECLARE @EXCLAMATION VARCHAR(20),@STAR VARCHAR(20),@SINGLE_QUOTATION VARCHAR(20),@OPEN_PARENTHESIS VARCHAR(20),@CLOSE_PARENTHESIS VARCHAR(20),@SEMI_COLON VARCHAR(20),@COLON VARCHAR(20),@AT_SIGN VARCHAR(20),@AMPERSIGN VARCHAR(20),@EQUALS VARCHAR(20),@PLUS VARCHAR(20),@DOLLAR VARCHAR(20),@FORWARD_SLASH VARCHAR(20),@QUESTION_MARK VARCHAR(20),@PERCENT VARCHAR(20),@NUMBER_SIGN VARCHAR(20),@OPEN_BRACKET VARCHAR(20),@CLOSE_BRACKET VARCHAR(20)


SELECT @EXCLAMATION =
'0.21%',--!@STAR ='%2A',--*@SINGLE_QUOTATION ='0.27%',--'@OPEN_PARENTHESIS ='0.28%',--(@CLOSE_PARENTHESIS ='0.29%',--)@SEMI_COLON ='%3B',--;@COLON ='%3A',--:@AT_SIGN ='0.4%',--@@AMPERSIGN ='0.26%',--&@EQUALS ='%3D',--=@PLUS ='%2B',--+@DOLLAR ='0.24%',--$@COMMA ='%2C',--,@FORWARD_SLASH ='%2F',--/@QUESTION_MARK ='%3F',--?@PERCENT ='0.25%',--%@NUMBER_SIGN ='0.23%',--#@OPEN_BRACKET ='%5B',--[@CLOSE_BRACKET ='%5D'--]


declare @space varchar(20),@exclamationpoint varchar(20),@doublequotes varchar(20),@numbersign varchar(20),@dollarsign varchar(20),@percentsign varchar(20),@ampersand varchar(20),@singlequote varchar(20),@openingparenthesis varchar(20),@closingparenthesis varchar(20),@asterisk varchar(20),@plussign varchar(20),@comma varchar(20),@minussignhyphen varchar(20),@period varchar(20),@slash varchar(20)
-----------------------------set @space =' 'set @exclamationpoint='!'set @doublequotes ='"'set @numbersign ='#'set @dollarsign='set @percentsign ='%'set @ampersand ='&'set @singlequote=''''set @openingparenthesis ='('set @closingparenthesis =')'set @asterisk ='*'set @plussign ='+'set @comma =','set @minussignhyphen ='-'set @period ='.'
set @slash ='/'

set @percentsign ='%'

set @ampersand ='&'

set @singlequote=''''

set @openingparenthesis ='('

set @closingparenthesis =')'

set @asterisk ='*'

set @plussign ='+'

set @comma =','

set @minussignhyphen ='-'

set @period ='.'

set @slash ='/'