Error converting data type nvarchar to float in SQL Server 2012
<p>I have the below code</p>

<pre><code>SELECT DISTINCT
    S.SCOPE
    ,convert(nvarchar, getdate(), 112) AS EFFECTIVE_START_TIME
    ,'99991231' AS EFFECTIVE_END_TIME
    ,LV.UOM_CODE
    ,'Gross Price' AS COLUMN_NAME_0
    ,CONVERT(float,LV2.VALUE_0) * CONVERT(float,LV.VALUE_1) AS VALUE_0  
    ,'Quantity' AS COLUMN_NAME_1
    ,LV.VALUE_1
FROM 
    PM_SCOPE S 
JOIN 
    PM_LOOKUP_VALUE LV ON S.SCOPE_ID = LV.SCOPE_ID
JOIN 
    PM_LOOKUP_DEFINITION LD ON LD.LOOKUP_DEFINITION_ID = LV.LOOKUP_DEFINITION_ID
JOIN 
    PM_SCOPE S2 ON S2.COMP_PRODUCT = S.COMP_PRODUCT  
JOIN 
    PM_LOOKUP_VALUE LV2 ON LV2.SCOPE_ID = S2.SCOPE_ID
JOIN 
    PM_LOOKUP_DEFINITION LD2 ON LD2.LOOKUP_DEFINITION_ID = LV2.LOOKUP_DEFINITION_ID
WHERE 
    LD.LOOKUP_NAME = 'Competitor Bundle Details' 
    AND LD2.LOOKUP_NAME = 'Competitor Gross Price List'
    AND S.GEOGRAPHY = S2.GEOGRAPHY
    AND CONVERT(VARCHAR, LV2.UPDATED_AT, 112)  &gt; CONVERT(VARCHAR, LV.UPDATED_AT, 112) 
</code></pre>

<p>When I run it, I get this error </p>

<blockquote>
  <p>Msg 8114, Level 16, State 5, Line 1<br>
  Error converting data type nvarchar to float.</p>
</blockquote>

<p>However when I comment out the below line, it works</p>

<pre><code>AND CONVERT(VARCHAR, LV2.UPDATED_AT, 112)  &gt; CONVERT(VARCHAR, LV.UPDATED_AT, 112) 
</code></pre>

<p>I looked at the data and unable to figure out the reason I see this error.</p>

<p>I also looked at the existing posts for this error and they don't seem to help me.</p>