SELECT. Need Advice. How Should I Code This?

Hello,

I need a procedure to return the value of field [ContentHtml] given values for [ContentName] and [ContentCulture].

In theory only one record will be found so only one [ContentHtml] value will be returned.

If multiple records are found I want to return "#MultipleFound#".
If no record is found I want to return "#NotFound#".

In my .NET code I am executing a ExecuteScalar:
  Dim Html As String = CType(command.ExecuteScalar, String)

I believe I should use @@ROWCOUNT to do this.

Could somebody explain to me how to integrate @@ROWCOUNT in my procedure code to achieve what I described?

And should I do it this way or there is a better solution?

My Procedure is as follows:

    -- Define the procedure parameters
  @ContentName NVARCHAR(100),
  @ContentCulture NVARCHAR(5)

AS

-- Allows @@ROWCOUNT and the return of number of records when ExecuteNonQuery is used
SET NOCOUNT OFF;

-- Declare and define ContentId
DECLARE @ContentId UNIQUEIDENTIFIER;
SELECT @ContentId = ContentId FROM dbo.by27_Content WHERE ContentName = @ContentName

-- Check if ContentId is Not Null
IF @ContentId IS NOT NULL
  BEGIN
    
    -- Select localized content from by27_ContentLocalized
    SELECT dbo.by27_ContentLocalized.ContentHtml
    FROM dbo.by27_Content
    INNER JOIN dbo.by27_ContentLocalized
      ON dbo.by27_Content.ContentId = dbo.by27_ContentLocalized.ContentId
      WHERE (dbo.by27_ContentLocalized.ContentCulture = @ContentCulture AND dbo.by27_Content.ContentName = @ContentName);

  END

Thanks,
Miguel