professional question
From: Peter Wilk <PeterWilk_at_compuserve.com>
Date: Sun, 11 Apr 1999 22:18:48 +0200
Message-ID: <7er001$p21$1_at_orudios.magnet.at>
[Quoted] how to substitute the case-statement in MS-SQL Server syntax in ORACLE
FROM SESSIONS; TIA
Date: Sun, 11 Apr 1999 22:18:48 +0200
Message-ID: <7er001$p21$1_at_orudios.magnet.at>
[Quoted] how to substitute the case-statement in MS-SQL Server syntax in ORACLE
for example:
SELECT RefURL=MAX( CASE WHEN CHARINDEX('?', Referer) > 5 THEN
SUBSTRING(Referer, 1, CHARINDEX('?', Referer) - 1
ELSE Referer
END
)
FROM SESSIONS; TIA
-- Peter Wilk Assistance and Insurance Consulting http://ourworld.compuserve.com/homepages/PeterWilkReceived on Sun Apr 11 1999 - 22:18:48 CEST