Re: No support for CASE keyword??

If U are working on Sybase SQL Server 11.0 and less, CASE expression is not supported, and Sybase Adaptive Server 11.5 started supporting it.

In article <Pine.BSI.3.96.980622171513.15376B-100000_at_prima.netfront.net>,   "johnnie (isg cooper)" <johnnie_at_prima.netfront.net> wrote:
>
> 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?
> >
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue Jun 23 1998 - 00:00:00 CDT