title: How do I write Sql server delete statement where a column value starts with the value of a parameter
body: <p>Here is what I have written below </p>
  
  <pre><code>CREATE PROCEDURE [dbo].[storedProcedureName]
  @parameterName char 
  AS
  BEGIN
  DELETE FROM Table
  WHERE Table_ColumnNames like @parameterName%
  END
  </code></pre>
  
  <p>Normally without a parameter I can write something like this (below) and this deletes every row that has name that starts with Adam in the ColumnName column. How do I achieve the same thing with a parameter which I have attempted above, I don't want it only to delete names that matches the parameterName but also names that starts with the value of parameterName. </p>
  
  <pre><code>CREATE PROCEDURE [dbo].[storedProcedureName]
  AS
  BEGIN
  DELETE FROM Table
  WHERE Table_ColumnNames like 'Adam%'
  END
  </code></pre>