USP_MATCH_CIPHER_FOR_LOGIN

      create procedure dbo.USP_MATCH_CIPHER_FOR_LOGIN
      (
          @CIPHER nvarchar(1500), 
          @PLAINTEXT nvarchar(255)
      )
      as
      begin

        declare @IsValid bit
        exec @IsValid = UFN_CIPHER_MATCH @PLAINTEXT, @CIPHER

        if @IsValid =1 
        begin
          select 1 as IsValid
        end
        else 
        begin
          select 0 as IsValid
        end
      end