>>Yes, it can be used to get such result but it would be slower that using IIF() aproch which works in any VFP version.
>
>Thanks. Do you have examples of each method available that you could share? Would appreciate seen them.
Hi Alex,
Here's IIF method.
SELECT id, ;
SUM(IIF(column_name = "January", value, 0) AS January, ;
...
SUM(IIF(column_name = "December", value, 0) AS December ;
FROM mytable ;
GROUP BY id
--sb--