SQL DISTINCT is not removing duplicates
<p>I have used below query to remove duplicates.But still it shows duplicates.Can you tell me why? </p>

<pre><code>select DISTINCT a.Company 
from [Legacy].[dbo].[Attorney] as a 
</code></pre>

<p><a href="https://i.stack.imgur.com/lavQ0.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/lavQ0.jpg" alt="enter image description here"></a></p>

<p><strong>Update :</strong> Below one is also not working.Can you tell me why ? </p>

<pre><code>select DISTINCT ltrim(rtrim(a.Company)) from [Legacy].[dbo].[Attorney] as a
</code></pre>

<p><strong>Update 2 :</strong> Now,it's showing 3.I don't know why ? </p>

<pre><code>select  DISTINCT ltrim(rtrim(a.Company)),convert(varbinary(100), a.Company) from [Legacy].[dbo].[Attorney] as a  
</code></pre>

<p><a href="https://i.stack.imgur.com/M7O3p.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/M7O3p.jpg" alt="enter image description here"></a></p>