Re: No support for CASE keyword??

From: Andrew Prosser <andrew_at_prosser1.demon.co.uk>
Date: 1998/06/24
Message-ID: <898664497.4042.0.nnrp-03.9e9803d5@news.demon.co.uk>#1/1

johnnie (isg cooper) wrote in message ...
>It seems that sybase ASE 11.5 CASE and MS-SQLServer 6.0 CASE statement is
>exactly the same. Am I right?
>

Yes, as they are both SQL-92 compliant

MS;

The CASE expression allows SQL expressions to be simplified for conditional values. The CASE expression in SQL Server 6.0 is ANSI SQL-92-compliant and allowed anywhere an expression is used.

Sybase;

Standards and Compliance
Standard Compliance Level
SQL92Transact-SQL extension

Regards

--
Andrew Prosser

Received on Wed Jun 24 1998 - 00:00:00 CDT