CASE statement in SYBASE not support

SYBASE 11.0.2
Where find  Sybase from version 11.5?

To upgrade your Sybase ASE license, contact Sybase customer service.  In the USA the number is 1-800-879-2273, in other countries it will be different, but you should be able to find contact information off of http://www.sybase.com.  In fact, you can also buy the software through the "e-shop" link at that site.

Note that 11.5 is being end-of-lifed in a few months, you will want to get at least 11.9.2 and should consider 12.0.x.

if I not upgrade SYBASE
Have other way use like case statement?

Who have SYBASE error information list.

How much money SYBASE verison 11.5 ?

What you can do is use this statement:

select f1 = abs(sign(a1 - 1))
from t1

It will give the same result. However this works only for the given query, for other case-like statements you will need to add extra calculations. This is the way most queries of this type were done before version 11.5.


Bret  why always post answers with non-information? A link to the sybase homepage is not really the answer to this question. Is that how you became numer one, by autogrades?

to hoor:
not only this
for example:
select f1=case
 when substring(a1,1,1)='1' then 'aaa'      
 else 'bbb' end from t1

A good general reference for this kind of query (called a "point characteristic function")  is
"Optimizing Transact SQL: Advanced Programming Techniques" by
Rozenshtein, Abramovich, and Birger; SQL Forum Press (http://www.sqlforum.com), ISBN 0-9649812-0-3

A specific solution to your new example might go like this:

The general point characterisitic function for equality of two items is

1-abs(sign(A-B))

this returns a 1 if the two items are equal, and a 0 otherwise, so a solution is to take the substring of either the first 3 or second three
of the string "bbbaaa" based on the output of the point characteristic function:

SELECT
  substring("bbbaaa", (1+(3*
            1-abs(sign(ascii(substring(a1,1,1) - acsii("1") ) )
   )), 3)
FROM t1

Regarding your question about the cost of ASE 11.5,
Sybase is ending support for ASE 11.5 on most platforms as of Dec 31st, so I would not expect it to be available, but ASE 11.9.2.x and ASE 12.0.x are both available.

The cost will depend on a number of factors, such as how you will be using it, the number of users, and the type of users (known users or internet connections, for instance).  

In general, my understanding is that if you have a current license, you may upgrade for no cost.  There are is also a version on Linux that is free for development use.  On other platforms, it appears that ASE 12.0 is available on a number of platforms through the "e-shop" link for
US$ 3,995, I think this includes a 5-seat license.    

Sorry, missed a closing ")" within the characteristic function, should be:


                    SELECT
                      substring("bbbaaa", (1+(3*
                                1-abs(sign(ascii(substring(a1,1,1)) - acsii("1") ) )
                       )), 3)
                    FROM t1

Very good... so you can use the 'old' syntax if you want to as I and Bret have proven. Works best with numbers, because the example with 'bbb' and 'aaa' will not work if you use columns...

Arjan

Dear: bret

I've rejected your proposed answer as Experts Exchange holds an experiment to work without the answer button.

See:        http://www.experts-exchange.com/jsp/communityNews.jsp
Paragraph: Site Update for Wednesday, November 06, 2002

By this rejection the Asker will be notified by mail and hopefully he will take his responsibility to finalize the question or post an additional comment.
The Asker sees a button beside every post which says "Accept This Comment As Answer" (including rejected answers) -- so if he/she thinks yours is the best, you'll be awarded the points and the grade.

Thanks !

modulo

Community Support Moderator
Experts Exchange