/*
Created by Chrissy LeMaire (clemaire@gmail.com)
Website: http://netnerds.net/

This T-SQL UDF does the following
1. Guesses the search engine's search keyword delimiter
2. Finds the search term and extracts it
3. Replaces querystring percentage encoding with its human readable equiv.

NO WARRANTIES, USE THIS AT YOUR OWN RISK, etc.
*/

CREATE FUNCTION [dbo].[QSCleaner] (@strURL varchar(512))
RETURNS varchar(255)
AS
BEGIN
DECLARE @ampStart int
DECLARE @queryStr varchar(512)
DECLARE @slashStart int
DECLARE @strDelimiter varchar(64)

--Clean up some stuff that gets in the way of q=
SET @strURL = REPLACE(@strURL, 'aq=', 'aa=')
SET @strURL = REPLACE(@strURL, 'as_q=', 'aa=') 
SET @strURL = REPLACE(@strURL, 'as_oq=', 'aa=')
SET @strURL = REPLACE(@strURL, 'as_eq=', 'aa=')

--Get Delimiter
WHILE @strDelimiter IS NULL
BEGIN
		-- most used search delimiters
		IF CHARINDEX('q=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'q='
		BREAK
		END
		
		IF CHARINDEX('p=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'p='
		BREAK
		END
		
		IF CHARINDEX('query=',@strURL) > 0
		BEGIN
		SET @strDelimiter = '='
		BREAK
		END
		
		IF CHARINDEX('search=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'search='
		BREAK
		END
		
		IF CHARINDEX('qry=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'qry='
		BREAK
		END
		
		IF CHARINDEX('p=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'p='
		BREAK
		END
		
		IF CHARINDEX('keywords=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'keywords='
		BREAK
		END
		
		IF CHARINDEX('keyword=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'keyword='
		BREAK
		END
		
		IF CHARINDEX('Keywords=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'Keywords='
		BREAK
		END
		
		IF CHARINDEX('MT=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'MT='
		BREAK
		END
		
		IF CHARINDEX('s=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 's='
		BREAK
		END
		
		IF CHARINDEX('key=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'key='
		BREAK
		END
		-- end most used
		
		IF CHARINDEX('B1=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'B1='
		BREAK
		END
		
		IF CHARINDEX('Claus=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'Claus='
		BREAK
		END
		
		IF CHARINDEX('DTqb1=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'DTqb1='
		BREAK
		END
		
		IF CHARINDEX('KERESES=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'KERESES='
		BREAK
		END
		
		IF CHARINDEX('KEY=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'KEY='
		BREAK
		END
		
		IF CHARINDEX('KeyWords=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'KeyWords='
		BREAK
		END
		
		IF CHARINDEX('PA=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'PA='
		BREAK
		END
		
		IF CHARINDEX('Q1=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'Q1='
		BREAK
		END
		
		IF CHARINDEX('QRY=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'QRY='
		BREAK
		END
		
		IF CHARINDEX('QUERY=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'QUERY='
		BREAK
		END
		
		IF CHARINDEX('Query=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'Query='
		BREAK
		END
		
		IF CHARINDEX('SEARCHSTRING=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'SEARCHSTRING='
		BREAK
		END
		
		IF CHARINDEX('SP=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'SP='
		BREAK
		END
		
		IF CHARINDEX('SearchString=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'SearchString='
		BREAK
		END
		
		IF CHARINDEX('SearchText=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'SearchText='
		BREAK
		END
		
		IF CHARINDEX('T=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'T='
		BREAK
		END
		
		IF CHARINDEX('Terms=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'Terms='
		BREAK
		END
		
		IF CHARINDEX('Text=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'Text='
		BREAK
		END
		
		IF CHARINDEX('Words=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'Words='
		BREAK
		END
		
		IF CHARINDEX('ara=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'ara='
		BREAK
		END
		
		IF CHARINDEX('as_q=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'as_q='
		BREAK
		END
		
		IF CHARINDEX('ask=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'ask='
		BREAK
		END
		
		IF CHARINDEX('begriff=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'begriff='
		BREAK
		END
		
		IF CHARINDEX('cadena=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'cadena='
		BREAK
		END
		
		IF CHARINDEX('eingabe=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'eingabe='
		BREAK
		END
		
		IF CHARINDEX('general=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'general='
		BREAK
		END
		
		IF CHARINDEX('in=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'in='
		BREAK
		END
		
		IF CHARINDEX('item=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'item='
		BREAK
		END
		
		IF CHARINDEX('jump=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'jump='
		BREAK
		END
		
		IF CHARINDEX('k=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'k='
		BREAK
		END
		
		IF CHARINDEX('key=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'key='
		BREAK
		END
		
		IF CHARINDEX('kw=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'kw='
		BREAK
		END
		
		IF CHARINDEX('look_for=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'look_for='
		BREAK
		END
		
		IF CHARINDEX('oldquery=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'oldquery='
		BREAK
		END
		
		IF CHARINDEX('palabras=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'palabras='
		BREAK
		END
		
		IF CHARINDEX('palavra=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'palavra='
		BREAK
		END
		
		IF CHARINDEX('q%3D',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'q%3D'
		BREAK
		END
		
		IF CHARINDEX('q1=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'q1='
		BREAK
		END
		
		IF CHARINDEX('qkw=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'qkw='
		BREAK
		END
		
		IF CHARINDEX('qr=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'qr='
		BREAK
		END
		
		IF CHARINDEX('qry=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'qry='
		BREAK
		END
		
		IF CHARINDEX('qs=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'qs='
		BREAK
		END
		
		IF CHARINDEX('qt=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'qt='
		BREAK
		END
		
		IF CHARINDEX('qu=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'qu='
		BREAK
		END
		
		IF CHARINDEX('queryText=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'queryText='
		BREAK
		END
		
		IF CHARINDEX('query_1=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'query_1='
		BREAK
		END
		
		IF CHARINDEX('queryterm=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'queryterm='
		BREAK
		END
		
		IF CHARINDEX('question=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'question='
		BREAK
		END
		
		IF CHARINDEX('qw=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'qw='
		BREAK
		END
		
		IF CHARINDEX('r=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'r='
		BREAK
		END
		
		IF CHARINDEX('request=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'request='
		BREAK
		END
		
		IF CHARINDEX('sTerm=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'sTerm='
		BREAK
		END
		
		IF CHARINDEX('sc=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'sc='
		BREAK
		END
		
		IF CHARINDEX('searchString=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'searchString='
		BREAK
		END
		
		IF CHARINDEX('searchWord=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'searchWord='
		BREAK
		END
		
		IF CHARINDEX('search_forquery=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'search_forquery='
		BREAK
		END
		
		IF CHARINDEX('search_string=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'search_string='
		BREAK
		END
		
		IF CHARINDEX('search_term=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'search_term='
		BREAK
		END
		
		IF CHARINDEX('searchfor=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'searchfor='
		BREAK
		END
		
		IF CHARINDEX('searchquery=',@strURL) > 0
		BEGIN
		SET @strDelimiter = '='
		BREAK
		END
		
		IF CHARINDEX('searchtext=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'searchquery='
		BREAK
		END
		
		IF CHARINDEX('soegeord=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'soegeord='
		BREAK
		END
		
		IF CHARINDEX('srch=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'srch='
		BREAK
		END
		
		IF CHARINDEX('str=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'str='
		BREAK
		END
		
		IF CHARINDEX('string=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'string='
		BREAK
		END
		
		IF CHARINDEX('su=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'su='
		BREAK
		END
		
		IF CHARINDEX('suche=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'suche='
		BREAK
		END
		
		IF CHARINDEX('suchstr=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'suchstr='
		BREAK
		END
		
		IF CHARINDEX('szukaj=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'szukaj='
		BREAK
		END
		
		IF CHARINDEX('t=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 't='
		BREAK
		END
		
		IF CHARINDEX('term=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'term='
		BREAK
		END
		
		IF CHARINDEX('terml=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'terml='
		BREAK
		END
		
		IF CHARINDEX('terms=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'terms='
		BREAK
		END
		
		IF CHARINDEX('text=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'text='
		BREAK
		END
		
		IF CHARINDEX('u=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'u='
		BREAK
		END
		
		IF CHARINDEX('w=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'w='
		BREAK
		END
		
		IF CHARINDEX('web/',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'web/'
		BREAK
		END
		
		IF CHARINDEX('what=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'what='
		BREAK
		END
		
		IF CHARINDEX('word=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'word='
		BREAK
		END
		
		IF CHARINDEX('words=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'words='
		BREAK
		END
		
		IF CHARINDEX('x=',@strURL) > 0
		BEGIN
		SET @strDelimiter = 'x='
		BREAK
		END

IF @strDelimiter IS NULL SET @strDelimiter = ''
END

	IF CHARINDEX(@strDelimiter,@strURL) > 0
	BEGIN
	SET	@queryStr = SUBSTRING(@strURL,CHARINDEX(@strDelimiter,@strURL)+LEN(@strDelimiter),LEN(@strURL))
	SET	@ampStart = CHARINDEX('&',@queryStr)
	IF @ampStart > 0 SET @queryStr = LEFT(@queryStr,@ampStart-1)							
		
	SET	@slashStart = CHARINDEX('/',@queryStr)
	IF @slashStart > 0 SET @queryStr = LEFT(@queryStr,@slashStart-1)	
	SET @queryStr = REPLACE(@queryStr, '%20', ' ')
	SET @queryStr = REPLACE(@queryStr, '%21', '!')
	SET @queryStr = REPLACE(@queryStr, '%22', '"')
	SET @queryStr = REPLACE(@queryStr, '%23', '#')
	SET @queryStr = REPLACE(@queryStr, '%24', '$')
	SET @queryStr = REPLACE(@queryStr, '%25', '%')
	SET @queryStr = REPLACE(@queryStr, '%26', '&')
	SET @queryStr = REPLACE(@queryStr, '%27', '''')
	SET @queryStr = REPLACE(@queryStr, '%28', '(')
	SET @queryStr = REPLACE(@queryStr, '%29', ')')
	SET @queryStr = REPLACE(@queryStr, '%2A', '*')
	SET @queryStr = REPLACE(@queryStr, '%2B', '+')
	SET @queryStr = REPLACE(@queryStr, '%2C', ',')
	SET @queryStr = REPLACE(@queryStr, '%2D', '-')
	SET @queryStr = REPLACE(@queryStr, '%2E', '.')
	SET @queryStr = REPLACE(@queryStr, '%2F', '/')
	SET @queryStr = REPLACE(@queryStr, '%30', '0')
	SET @queryStr = REPLACE(@queryStr, '%31', '1')
	SET @queryStr = REPLACE(@queryStr, '%32', '2')
	SET @queryStr = REPLACE(@queryStr, '%33', '3')
	SET @queryStr = REPLACE(@queryStr, '%34', '4')
	SET @queryStr = REPLACE(@queryStr, '%35', '5')
	SET @queryStr = REPLACE(@queryStr, '%36', '6')
	SET @queryStr = REPLACE(@queryStr, '%37', '7')
	SET @queryStr = REPLACE(@queryStr, '%38', '8')
	SET @queryStr = REPLACE(@queryStr, '%39', '9')
	SET @queryStr = REPLACE(@queryStr, '%3A', ':')
	SET @queryStr = REPLACE(@queryStr, '%3B', ';')
	SET @queryStr = REPLACE(@queryStr, '%3C', '<')
	SET @queryStr = REPLACE(@queryStr, '%3D', '=')
	SET @queryStr = REPLACE(@queryStr, '%3E', '>')
	SET @queryStr = REPLACE(@queryStr, '%3F', '?')
	SET @queryStr = REPLACE(@queryStr, '%40', '@')

	SET @queryStr = REPLACE(@queryStr, '%5B', '[')
	SET @queryStr = REPLACE(@queryStr, '%5C', '\')
	SET @queryStr = REPLACE(@queryStr, '%5D', ']')
	SET @queryStr = REPLACE(@queryStr, '%5E', '^')
	SET @queryStr = REPLACE(@queryStr, '%5F', '_')
	SET @queryStr = REPLACE(@queryStr, '%60', '`')

	SET @queryStr = REPLACE(@queryStr, '%7B', '{')
	SET @queryStr = REPLACE(@queryStr, '%7C', '|')
	SET @queryStr = REPLACE(@queryStr, '%7D', '}')
	SET @queryStr = REPLACE(@queryStr, '%7E', '~')
	SET @queryStr = REPLACE(@queryStr, '%IO', 'H')
	SET @queryStr = REPLACE(@queryStr, '%A0', ' ')
	SET @queryStr = REPLACE(@queryStr, '%A1', '¡')
	SET @queryStr = REPLACE(@queryStr, '%A2', '¢')
	SET @queryStr = REPLACE(@queryStr, '%A3', '£')
	SET @queryStr = REPLACE(@queryStr, '%A4', '¤')
	SET @queryStr = REPLACE(@queryStr, '%A5', '¥')
	SET @queryStr = REPLACE(@queryStr, '%A6', '¦')
	SET @queryStr = REPLACE(@queryStr, '%A7', '§')
	SET @queryStr = REPLACE(@queryStr, '%A8', '¨')
	SET @queryStr = REPLACE(@queryStr, '%A9', '©')
	SET @queryStr = REPLACE(@queryStr, '%AA', 'ª')
	SET @queryStr = REPLACE(@queryStr, '%AB', '«')
	SET @queryStr = REPLACE(@queryStr, '%AC', '')
	SET @queryStr = REPLACE(@queryStr, '%AD', '­')
	SET @queryStr = REPLACE(@queryStr, '%AE', '®')
	SET @queryStr = REPLACE(@queryStr, '%AF', '¯')
	SET @queryStr = REPLACE(@queryStr, '%B0', '°')
	SET @queryStr = REPLACE(@queryStr, '%B1', '±')
	SET @queryStr = REPLACE(@queryStr, '%B2', '²')
	SET @queryStr = REPLACE(@queryStr, '%B3', '³')
	SET @queryStr = REPLACE(@queryStr, '%B4', '´')
	SET @queryStr = REPLACE(@queryStr, '%B5', 'µ')
	SET @queryStr = REPLACE(@queryStr, '%B6', '')
	SET @queryStr = REPLACE(@queryStr, '%B7', '·')
	SET @queryStr = REPLACE(@queryStr, '%B8', '¸')
	SET @queryStr = REPLACE(@queryStr, '%B9', '¹')
	SET @queryStr = REPLACE(@queryStr, '%BA', 'º')
	SET @queryStr = REPLACE(@queryStr, '%BB', '»')
	SET @queryStr = REPLACE(@queryStr, '%BC', '¼')
	SET @queryStr = REPLACE(@queryStr, '%BD', '½')
	SET @queryStr = REPLACE(@queryStr, '%BE', '¾')
	SET @queryStr = REPLACE(@queryStr, '%BF', '¿')
	SET @queryStr = REPLACE(@queryStr, '%C0', 'À')
	SET @queryStr = REPLACE(@queryStr, '%C1', 'Á')
	SET @queryStr = REPLACE(@queryStr, '%C2', 'Â')
	SET @queryStr = REPLACE(@queryStr, '%C3', 'Ã')
	SET @queryStr = REPLACE(@queryStr, '%C4', 'Ä')
	SET @queryStr = REPLACE(@queryStr, '%C5', 'Å')
	SET @queryStr = REPLACE(@queryStr, '%C6', 'Æ')
	SET @queryStr = REPLACE(@queryStr, '%C7', 'Ç')
	SET @queryStr = REPLACE(@queryStr, '%C8', 'È')
	SET @queryStr = REPLACE(@queryStr, '%C9', 'É')
	SET @queryStr = REPLACE(@queryStr, '%CA', 'Ê')
	SET @queryStr = REPLACE(@queryStr, '%CB', 'Ë')
	SET @queryStr = REPLACE(@queryStr, '%CC', 'Ì')
	SET @queryStr = REPLACE(@queryStr, '%CD', 'Í')
	SET @queryStr = REPLACE(@queryStr, '%CE', 'Î')
	SET @queryStr = REPLACE(@queryStr, '%CF', 'Ï')
	SET @queryStr = REPLACE(@queryStr, '%D0', 'Ð')
	SET @queryStr = REPLACE(@queryStr, '%D1', 'Ñ')
	SET @queryStr = REPLACE(@queryStr, '%D2', 'Ò')
	SET @queryStr = REPLACE(@queryStr, '%D3', 'Ó')
	SET @queryStr = REPLACE(@queryStr, '%D4', 'Ô')
	SET @queryStr = REPLACE(@queryStr, '%D5', 'Õ')
	SET @queryStr = REPLACE(@queryStr, '%D6', 'Ö')
	SET @queryStr = REPLACE(@queryStr, '%D7', '×')
	SET @queryStr = REPLACE(@queryStr, '%D8', 'Ø')
	SET @queryStr = REPLACE(@queryStr, '%D9', 'Ù')
	SET @queryStr = REPLACE(@queryStr, '%DA', 'Ú')
	SET @queryStr = REPLACE(@queryStr, '%DB', 'Û')
	SET @queryStr = REPLACE(@queryStr, '%DC', 'Ü')
	SET @queryStr = REPLACE(@queryStr, '%DD', 'Ý')
	SET @queryStr = REPLACE(@queryStr, '%DE', 'Þ')
	SET @queryStr = REPLACE(@queryStr, '%DF', 'ß')
	SET @queryStr = REPLACE(@queryStr, '%E0', 'À')
	SET @queryStr = REPLACE(@queryStr, '%E1', 'Á')
	SET @queryStr = REPLACE(@queryStr, '%E2', 'Â')
	SET @queryStr = REPLACE(@queryStr, '%E3', 'Ã')
	SET @queryStr = REPLACE(@queryStr, '%E4', 'Ä')
	SET @queryStr = REPLACE(@queryStr, '%E5', 'Å')
	SET @queryStr = REPLACE(@queryStr, '%E6', 'Æ')
	SET @queryStr = REPLACE(@queryStr, '%E7', 'Ç')
	SET @queryStr = REPLACE(@queryStr, '%E8', 'È')
	SET @queryStr = REPLACE(@queryStr, '%E9', 'É')
	SET @queryStr = REPLACE(@queryStr, '%EA', 'Ê')
	SET @queryStr = REPLACE(@queryStr, '%EB', 'Ë')
	SET @queryStr = REPLACE(@queryStr, '%EC', 'Ì')
	SET @queryStr = REPLACE(@queryStr, '%ED', 'Í')
	SET @queryStr = REPLACE(@queryStr, '%EE', 'Î')
	SET @queryStr = REPLACE(@queryStr, '%EF', 'Ï')
	SET @queryStr = REPLACE(@queryStr, '%F0', 'Ð')
	SET @queryStr = REPLACE(@queryStr, '%F1', 'Ñ')
	SET @queryStr = REPLACE(@queryStr, '%F2', 'Ò')
	SET @queryStr = REPLACE(@queryStr, '%F3', 'Ó')
	SET @queryStr = REPLACE(@queryStr, '%F4', 'Ô')
	SET @queryStr = REPLACE(@queryStr, '%F5', 'Õ')
	SET @queryStr = REPLACE(@queryStr, '%F6', 'Ö')
	SET @queryStr = REPLACE(@queryStr, '%F7', '÷')
	SET @queryStr = REPLACE(@queryStr, '%F8', 'Ø')
	SET @queryStr = REPLACE(@queryStr, '%F9', 'Ù')
	SET @queryStr = REPLACE(@queryStr, '%FA', 'Ú')
	SET @queryStr = REPLACE(@queryStr, '%FB', 'Û')
	SET @queryStr = REPLACE(@queryStr, '%FC', 'Ü')
	SET @queryStr = REPLACE(@queryStr, '%FD', 'Ý')
	SET @queryStr = REPLACE(@queryStr, '%FE', 'Þ')
	SET @queryStr = REPLACE(@queryStr, '%FF', 'Ÿ')
	SET @queryStr = REPLACE(@queryStr, '+', ' ')

	END
if @queryStr is null SET @queryStr = @strURL
RETURN  @queryStr
END