Re: Transpose in SQL

In Sybase, the CASE keyword is for scripting use. It can't be embedded in an SQL Statement.

You can transpose rows to columns and visa versa in a single Sybase SQL statement by using Sybase's characteristic functions and add'l functions. These include (SIGN, ABS, ISNULL, SUBSTRING, etc)

How you combine them depends on what you're trying to do. There are excellent books on the topic published by the SQL Forum Press. Received on Mon Oct 26 1998 - 00:00:00 CST