I need to write a stored procedure that will change or update a boolean field to true if it is false, and false if it is true. In order to update the correct record, I need to use the record number as a parameter.Thanks !

ALTER PROCEDURE [dbo].[spCheckActivePaient]
-- Add the parameters for the stored procedure here
@MR varchar(50)
AS
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON
-- Insert statements for procedure here
Thanks but where is the part that will determine if Active is true? And if it is true I want to update it to false????
SELECT ~Active , LastName,Active
FROM Demographics
WHERE MR=@MR

ALTER PROCEDURE [dbo].[spCheckActivePaient]
-- Add the parameters for the stored procedure here
@MR varchar(50)
AS
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON
-- Insert statements for procedure here
Thanks but where is the part that will determine if Active is true? And if it is true I want to update it to false????
SELECT ~Active , LastName,Active
FROM Demographics
WHERE MR=@MR

ALTER PROCEDURE [dbo].[spCheckActivePaient]
-- Add the parameters for the stored procedure here
@MR varchar(50)
AS
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON
-- Insert statements for procedure here
Thanks but where is the part that will determine if Active is true? And if it is true I want to update it to false????
SELECT ~Active , LastName,Active
FROM Demographics
WHERE MR=@MR