update 
--select * from
[pec].[dbo].[PECActivations]
set status =3 ,
  letterSentDate= getdate(),
  StatusMessage = StatusMessage +' '+ CONVERT(VARCHAR(19), GETDATE(), 20)+ ' Manually Sent'
  where  status =40 and
  CreatedDate> '2015-02-27'