dbWriter.com SQL FUNCTION GET

CREATE FUNCTION dbo.GET_BROWSER (@BROWSER varchar(255))
RETURNS Varchar(255)
AS
BEGIN
DECLARE @RR varchar(255)
Select @RR =

CASE

--Opera
WHEN PATINDEX('%Opera 1%', @Browser) > 0 THEN 'Opera 1'
WHEN PATINDEX('%Opera 2%', @Browser) > 0 THEN 'Opera 2'
WHEN PATINDEX('%Opera 3%', @Browser) > 0 THEN 'Opera 3'
WHEN PATINDEX('%Opera 4%', @Browser) > 0 THEN 'Opera 4'
WHEN PATINDEX('%Opera 5%', @Browser) > 0 THEN 'Opera 5'
WHEN PATINDEX('%Opera 6%', @Browser) > 0 THEN 'Opera 6'
WHEN PATINDEX('%Opera 7%', @Browser) > 0 THEN 'Opera 7'
WHEN PATINDEX('%Opera 8%', @Browser) > 0 THEN 'Opera 8'
WHEN PATINDEX('%Opera%', @Browser) > 0 THEN 'Opera'

--AOL
WHEN PATINDEX('%AOL 3%', @Browser) > 0 THEN 'AOL 3'
WHEN PATINDEX('%AOL 4%', @Browser) > 0 THEN 'AOL 4'
WHEN PATINDEX('%AOL 5%', @Browser) > 0 THEN 'AOL 5'
WHEN PATINDEX('%AOL 6%', @Browser) > 0 THEN 'AOL 6'
WHEN PATINDEX('%AOL 7%', @Browser) > 0 THEN 'AOL 7'
WHEN PATINDEX('%AOL 8%', @Browser) > 0 THEN 'AOL 8'
WHEN PATINDEX('%AOL 9%', @Browser) > 0 THEN 'AOL 9'
WHEN PATINDEX('%AOL 10%', @Browser) > 0 THEN 'AOL 10'
WHEN PATINDEX('%AOL%', @Browser) > 0 THEN 'AOL'

--Konqueror
WHEN PATINDEX('%Konqueror%', @Browser) > 0 THEN 'Konqueror'

--EudoraWeb
WHEN PATINDEX('%EudoraWeb%', @Browser) > 0 THEN 'EudoraWeb'

--Dreamcast
WHEN PATINDEX('%Dreamcast%', @Browser) > 0 THEN 'Dreamcast'

--Safari
WHEN PATINDEX('%Safari%', @Browser) > 0 THEN 'Safari'

--Lynx
WHEN PATINDEX('%Lynx%', @Browser) > 0 THEN 'Lynx'

--ICE
WHEN PATINDEX('%ICE%', @Browser) > 0 THEN 'ICE'

--iCab
WHEN PATINDEX('%iCab%', @Browser) > 0 THEN 'iCab'

--HotJava
WHEN PATINDEX('%Sun%', @Browser) > 0 AND PATINDEX('%Mozilla/3%', @Browser) > 0 THEN 'HotJava'

--Galeon
WHEN PATINDEX('%Galeon%', @Browser) > 0 THEN 'Galeon'

--Epiphany
WHEN PATINDEX('%Epiphany%', @Browser) > 0 THEN 'Epiphany'

--DocZilla
WHEN PATINDEX('%DocZilla%', @Browser) > 0 THEN 'DocZilla'

--Camino
WHEN PATINDEX('%Chimera%', @Browser) > 0 THEN 'Camino'
WHEN PATINDEX('%Camino%', @Browser) > 0 THEN 'Camino'

--Dillo
WHEN PATINDEX('%Dillo%', @Browser) > 0 THEN 'Dillo'

--amaya
WHEN PATINDEX('%amaya%', @Browser) > 0 THEN 'Amaya'

--NetCaptor
WHEN PATINDEX('%NetCaptor%', @Browser) > 0 THEN 'NetCaptor'

--LookSmart search engine robot
WHEN PATINDEX('%ZyBorg%', @Browser) > 0 THEN 'LookSmart'

--Googlebot search engine robot
WHEN PATINDEX('%Googlebot%', @Browser) > 0 THEN 'Googlebot'

--MSN search engine robot
WHEN PATINDEX('%msnbot%', @Browser) > 0 THEN 'MSN'

--inktomi search engine robot
WHEN PATINDEX('%slurp%', @Browser) > 0 THEN 'Inktomi'

--AltaVista search engine robot
WHEN PATINDEX('%Scooter%', @Browser) > 0 THEN 'AltaVista'

--DMOZ search engine robot
WHEN PATINDEX('%Robozilla%', @Browser) > 0 THEN 'DMOZ'

--Ask Jeeves search engine robot
WHEN PATINDEX('%Ask Jeeves%', @Browser) > 0 THEN 'Ask Jeeves'
WHEN PATINDEX('%Ask+Jeeves%', @Browser) > 0 THEN 'Ask Jeeves'

--Lycos search engine robot
WHEN PATINDEX('%lycos%', @Browser) > 0 THEN 'Lycos'

--Excite search engine robot
WHEN PATINDEX('%ArchitextSpider%', @Browser) > 0 THEN 'Excite'

--Northernlight search engine robot
WHEN PATINDEX('%Gulliver%', @Browser) > 0 THEN 'Northernlight'

--AllTheWeb search engine robot
WHEN PATINDEX('%crawler@fast%', @Browser) > 0 THEN 'AllTheWeb'

--Turnitin search engine robot
WHEN PATINDEX('%TurnitinBot%', @Browser) > 0 THEN 'Turnitin'

--InternetSeer search engine robot
WHEN PATINDEX('%internetseer%', @Browser) > 0 THEN 'InternetSeer'

--NameProtect Inc. search engine robot
WHEN PATINDEX('%nameprotect%', @Browser) > 0 THEN 'NameProtect'

--PhpDig search engine robot
WHEN PATINDEX('%PhpDig%', @Browser) > 0 THEN 'PhpDig'

--Rambler search engine robot
WHEN PATINDEX('%StackRambler%', @Browser) > 0 THEN 'Rambler'

--UbiCrawler search engine robot
WHEN PATINDEX('%UbiCrawler%', @Browser) > 0 THEN 'UbiCrawler'

--entireweb search engine robot
WHEN PATINDEX('%Speedy+Spider%', @Browser) > 0 THEN 'entireweb'

--Alexa.com search engine robot
WHEN PATINDEX('%ia_archiver%', @Browser) > 0 THEN 'Alexa'

--Arianna/Libero search engine robot
WHEN PATINDEX('%arianna.libero.it%', @Browser) > 0 THEN 'Arianna/Libero'

--Internet Explorer
WHEN PATINDEX('%MSIE 7%', @Browser) > 0 THEN 'Microsoft IE 7'
WHEN PATINDEX('%MSIE 6%', @Browser) > 0 THEN 'Microsoft IE 6'
WHEN PATINDEX('%MSIE 5%', @Browser) > 0 THEN 'Microsoft IE 5'
WHEN PATINDEX('%MSIE 4%', @Browser) > 0 THEN 'Microsoft IE 4'
WHEN PATINDEX('%MSIE 3%', @Browser) > 0 THEN 'Microsoft IE 3'
WHEN PATINDEX('%MSIE 2%', @Browser) > 0 THEN 'Microsoft IE 2'
WHEN PATINDEX('%MSIE 1%', @Browser) > 0 THEN 'Microsoft IE 1'

--Pocket Internet Explorer
WHEN PATINDEX('%MSPIE 1%', @Browser) > 0 THEN 'Pocket IE 1'
WHEN PATINDEX('%MSPIE 2%', @Browser) > 0 THEN 'Pocket IE 2'

-- ********************************************* netscape needs to be before Mozilla
--Netscape
WHEN PATINDEX('%Netscape/10%', @Browser) > 0 THEN 'Netscape 10'
WHEN PATINDEX('%Netscape/9%', @Browser) > 0 THEN 'Netscape 9'
WHEN PATINDEX('%Netscape/8%', @Browser) > 0 THEN 'Netscape 8'
WHEN PATINDEX('%Netscape/7%', @Browser) > 0 THEN 'Netscape 7'
WHEN PATINDEX('%Netscape6%', @Browser) > 0 THEN 'Netscape 6'
WHEN PATINDEX('%Mozilla/4%', @Browser) > 0 THEN 'Netscape 4'
WHEN PATINDEX('%Mozilla/3%', @Browser) > 0 THEN 'Netscape 3'
WHEN PATINDEX('%Mozilla/2%', @Browser) > 0 THEN 'Netscape 2'
WHEN PATINDEX('%Mozilla/1%', @Browser) > 0 THEN 'Netscape 1'

--Mozilla Firefox
WHEN PATINDEX('%Gecko%', @Browser) > 0 AND PATINDEX('%Firefox%', @Browser) > 0 THEN 'Mozilla Firefox'

--Mozilla Firebird
WHEN PATINDEX('%Gecko%', @Browser) > 0 AND PATINDEX('%Firebird%', @Browser) > 0 THEN 'Mozilla Firebird'

--Mozilla
WHEN PATINDEX('%Gecko%', @Browser) > 0 AND PATINDEX('%rv:2%', @Browser) > 0 THEN 'Mozilla 2'
WHEN PATINDEX('%Gecko%', @Browser) > 0 AND PATINDEX('%rv:1%', @Browser) > 0 THEN 'Mozilla 1'
WHEN PATINDEX('%Gecko%', @Browser) > 0 AND PATINDEX('%rv:0%', @Browser) > 0 THEN 'Mozilla'

ELSE @Browser
END

RETURN @RR

END

Partners/Links