Database

select phone_number
from TABLENAME
group by phone_number
having count(phone_number) > 1

update TABLENAME
set status = abs(status - 1)  -- This means if status is 0, you get abs(-1) which = 1
where phone_number in 
(
select phone_number
from TABLENAME
group by phone_number
having count(phone_number) > 1
)

INSERT INTO EmployeeMaster (FirstName, LastName, EmpID)
SELECT EmpFirstName, EmpLastName, EmpID
FROM EmployeeTemp
WHERE (...........)

UPDATE EmployeeMaster
SET EmployeeMaster.FirstName = EmployeeTemp.EmpFirstName,
    EmployeeMaster.LastName = EmployeeTemp.EmpLastName,
    EmployeeMaster.EmpID = EmployeeTemp.EmpID
FROM EmployeeTemp T INNER JOIN EmployeeMaster M ON T.EmpID = M.EmpID
WHERE (...........)

declare @t table(record varchar(100))
insert into @t 
	select 'Hello-World' union all
	select 'code - project codes are good' union all
	select 'hello' union all
	select ' world' union all
	select ' how are u-?'

select * from @t where record like '%[-]%'

record
Hello-World
code - project codes are good
 how are u-?