The field type is varbinary now is going to do if judgment field, such as the if (name='xx', 1, 0) will be considered the name=xx is 0

CodePudding user response:

 according to your ideas should be: 
Case the convert (varchar (Max), name, 2) the when 'abcd' then one else 0 end 
It should be or better 
Case the name when the convert (varbinary (Max), 'abcd', 2) then one else 0 end