Re: No support for CASE keyword??

What is the difference between oracle DECODE and sql-server CASE function?

On Sat, 20 Jun 1998, Andrew Prosser wrote:

>
> DCMessier wrote in message
> <1998062003334400.XAA29240_at_ladder03.news.aol.com>...
> >I am responsible for a databsae maintenance application. We have a
 front-end
> >developed in VB 5 which uses stored procedures for all data access. We
 support
> >(at the present time) Microsoft SQL Server and Sybase SQL Server on the
> >back-end.
> >
> >I was quite disappointed to learn today, while attempting to wrap-up
 testing of
> >our current release, that Sybase Transact-SQL does NOT support the ANSI
 SQL-92
> >standard CASE expression. Does anyone know WHY??
> >
> >I was very upset, and wasted lots of time coming up with a work-around for
 this
> >untimely mess. Am I missing something here? Or is the only alternative to
 use
> >a complicated if..else construct?
> >
> >It's frustrating to do primary development on MS SQL Server, with the
> >expectation that Sybase will support STANDARD SQL syntax.
> >
> >Any suggestions out there?
>
  Received on Mon Jun 22 1998 - 00:00:00 CDT