in reply to Problem with case in select statement

The Select works fine in Sybase but in the code below it gives me errors.

My info on ODBC may be stale -- it's been a while since I've used it -- but doesn't ODBC define a subset of SQL, and then map between that subset and vendor-specific SQL? That is, arbitrary non-standard constructs like CASE aren't necessarily supported by ODBC.

I suggest getting your hands on some good ODBC documentation.

  • Comment on Re: Problem with case in select statement

In Section Seekers of Perl Wisdom