The Developer Zone

			
                            SELECT Category =
                                CASE type
                                    WHEN 'AN' THEN 'ASP.Net'
                                    WHEN 'VN' THEN 'VB.Net'
                                    WHEN 'CN' THEN 'C#.Net'
                                    ELSE 'Not categorized'
                                END,
                            Title, Price
                            FROM Books
                            ORDER BY Category