ALTER PROCEDURE dbo.DoesAccountExistByUsername(@Username varchar(255), @Exists bit OUTPUT) AS IF EXISTS(SELECT 'True' FROM Account WHERE UPPER(Username) = UPPER(@Username)) BEGIN SET @Exists = 1 RETURN END SET @Exists = 0 RETURN