I have a single table like create table Mytable (ID int identity, Name nvarchar(10)) Now I want to update my Name column like this Update MyTable set name = case ID when 1 then DEFAULT END But I am getting error >Incorrect syntax near the keyword 'DEFAULT' How can I use UPDATE with DEFAULT statement in CASE clause? I am using SQL Server 2014.