How to use case only to change several value in the column but still preserve the rest of the column values? The problem with the syntax below, it produce additional column as name [Vw-Model] but what I want is on existing column when the query found 'Kitara' then it will turn to 'Kitara-2'
seelct *, case when [Model18]='Kitara' then 'Kitara-2' ELSE 'Group Error'
END AS [Model_Grouping] from [Vw-Model]
where group_name ='CD3008'