how to select record in sql server if i want to select record with EmpId, EmpName,EmpDept from Table.
in EmpDept only 34 department but i want to display one more which is "Other Dept" but "Other Dept" is not is in record.
i dont want to store "Other Dept" in table.
i want to display while execute sql query.