Re: professional question

From: Christopher M. Day <christopher.day_at_rdbms.freeserve.co.uk>
Date: Sun, 11 Apr 1999 23:04:02 +0100
Message-ID: <37111C52.1BECA68B@rdbms.freeserve.co.uk>

Peter,

Try using the DECODE statement.

Chris

Peter Wilk wrote:
>
> 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 - 17:04:02 CDT