How to refactor the following sql statement? Declare @IsExistRoleAR As bit
Declare @IsExistRoleEN As bit
Declare @IsExist AS bit
set @IsExistRoleAR=(SELECT CASE WHEN COUNT(RoleID) &gt; 0 THEN 1 ELSE 0 END AS isExists
                    FROM Roles
                    WHERE RoleDescAR='Arabic Name') 

set @IsExistRoleEN=(SELECT CASE WHEN COUNT(RoleID) &gt; 0 THEN 1 ELSE 0 END AS isExists
FROM Roles
WHERE RoleDescEN='English Name') 

set @IsExist=(@IsExistRoleAR | @IsExistRoleEN)
select @IsExist
You could just use OR:

  SELECT CASE WHEN COUNT(RoleID) &gt; 0 THEN 1 ELSE 0 END AS isExists
  FROM Roles
  WHERE RoleDescAR='Arabic Name' OR RoleDescEN='English Name'