title: sql server matching 2 table columns for an exact word match
body: <p>I want to search a table's varchar column for content in another table's varchar column.</p>
  <p>Certain words are banned and I want to identify the rows that have the banned words. I want an EXACT match on the banned word.</p>
  <p>I'm using MS SQL Server 2016.</p>
  <p>Table 1:</p>
  <pre><code>CREATE TABLE [dbo].[BlogComment](
      [BlogCommentId] [int] IDENTITY(1,1) NOT NULL,
      [BlogCommentContent] [varchar](max) NOT NULL,
  CONSTRAINT [PK_BlogComment] PRIMARY KEY CLUSTERED 
  (
      [BlogCommentId] ASC
  )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = 
  ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
  </code></pre>
  <p>3 rows - and the data in BlogCommentContent:</p>
  <p>There are many of us.</p>
  <p>This is the man.</p>
  <p>I hear you.</p>
  <p>Table 2:</p>
  <pre><code>CREATE TABLE [dbo].[BannedWords](
      [BannedWordsId] [int] IDENTITY(1,1) NOT NULL,
      [Description] [varchar](250) NOT NULL
  CONSTRAINT [PK_BannedWords] PRIMARY KEY CLUSTERED 
  (
      [BannedWordsId] ASC
  )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = 
  ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  </code></pre>
  <p>3 rows - and the data in Description:</p>
  <p>though</p>
  <p>man</p>
  <p>hear</p>
  <hr />
  <p>My Sql:</p>
  <pre><code>SELECT BlogCommentContent
  FROM dbo.BlogComment,
       dbo.BannedWords
  WHERE ( CHARINDEX( [Description], BlogCommentContent, 1 ) ) &gt; 1
  </code></pre>
  <p>It's finding 'man', 'hear' and 'man' in the word 'many'.
  So it returns 3 rows.</p>
  <p>I only WANT EXACT matches.
  So only return 2 rows.</p>
  <p>How do I accomplish this?</p>