How to remove percentage symbol while extracting records
<p>I have the following table employee:</p>

<pre><code>Name Percentage
---------------
rad    80%
deepak 20%
kavita 30%
</code></pre>

<p>I want to write a SQL select query using SQL Server 2008 to returns these results:</p>

<pre><code>rad 80
deepak 20
kavita 30
</code></pre>

<p>How can this be achieved?</p>