How to refactor the following sql statement?
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'