in reply to Problem with case in select statement

There is no Case When in standard SQL (ANSI SQL 92) so your question is really something for a Sybase forum. It might be that in the Sybase SQL there is no such construct as well.

You could make the query a bit indented by the way.

  • Comment on Re: Problem with case in select statement

Replies are listed 'Best First'.
Re: Re: Problem with case in select statement
by SamueD2 (Novice) on Mar 21, 2003 at 16:55 UTC
    The Select statement works in Sybase
[reply]
      The Select statement works in Sybase

      Perhaps, but you're going through ODBC to get there,. I'll bet the error that's getting coughed up (the one you haven't shown) is from ODBC.

      Show us the error message.

[reply]
      It might be possible that the select statement is just too long for the library.
[reply]

In Section Seekers of Perl Wisdom