professional question

From: Peter Wilk <PeterWilk_at_compuserve.com>
Date: Sun, 11 Apr 1999 22:18:28 +0200
Message-ID: <7eqvvd$p1v$1@orudios.magnet.at>

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/PeterWilk Received on Sun Apr 11 1999 - 15:18:28 CDT