title: Removing the first 5 characters of each entry of a column STORED PROCEDURE
body: <p>I have the table <strong>reservation</strong> and in that table there is a column called <strong>campground</strong>.
  Every entry of the campground column is very similar to the other ones e.g.:</p>
  <p>﻿ALBE/Alberta Beach Family RV Park</p>
  <p><strong>Can someone tell me how to remove the first 5 characters of every entry in this column using a stored procedure which removes 5 characters from every entry in this column?</strong></p>
  <p>The code I've tried so far is the following:</p>
  <pre><code>﻿UPDATE reservation
  SET RIGHT(campground, LEN(campground) - 5)
  </code></pre>
  <p>Can someone help me creating a stored procedure with the functionality mentioned above?</p>
  <p>Thanks!!</p>