No support for CASE keyword??

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 Sat Jun 20 1998 - 00:00:00 CDT