<pre lang="SQL"><pre lang="SQL"><pre lang="SQL">
CASE WHEN ID =100 THEN 'GROUP-A' WHEN ID= 105 THEN 'GROUP-B' ELSE 'Group-C' END
SELECT * ,Case WHEN ID =100 THEN 'GROUP-A' WHEN ID= 105 THEN 'GROUP-B' ELSE 'Unknown' END
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)