title: Msg 8114, Level 16, State 5, Line 1 Error converting data type nvarchar to real
body: <p>Presently, I am executing the following query and receiving the above error message:</p>
  
  <pre><code>SELECT dbo.qryOtherFieldDataVerifySource.ItemID,
         dbo.qryOtherFieldDataVerifySource.EDGRDataID,
         dbo.qryOtherFieldDataVerifySource.LineItemID,
         dbo.qryOtherFieldDataVerifySource.ZEGCodeID,
         dbo.qryOtherFieldDataVerifySource.DataValue,
         dbo.tblBC.AcceptableValues,
         dbo.qryOtherFieldDataVerifySource.DataUnitID,
         dbo.qryOtherFieldDataVerifySource.DataDate,
         dbo.tblBC.DataTypeID,
         CASE
           WHEN DataTypeID = '{5951994B-BF47-4117-805D-B8F85FAB76A8}'
                AND ISNUMERIC(DataValue) = 1 THEN ( CASE
                                                      WHEN CAST(DataValue AS FLOAT(8)) &gt;= 0 THEN 1
                                                      ELSE 0
                                                    END )
           ELSE 0
         END AS ValidPositiveNumericValue,
         CASE DataTypeID
          WHEN '{A6317BA5-F8FB-4866-A26B-24594650C2DC}'THEN ( CASE UPPER(DataValue)
          WHEN 'TRUE' THEN 1
          WHEN 'FALSE' THEN 1
          WHEN 'YES' THEN 1
          WHEN 'NO' THEN 1
          WHEN 'Y' THEN 1
          WHEN 'N' THEN 1
          WHEN '0' THEN 1
          WHEN '1' THEN 1
          ELSE 0
        END )
           WHEN '{5951994B-BF47-4117-805D-B8F85FAB76A8}' THEN ISNUMERIC(DataValue)
           ELSE 1
         END AS ValidDataType,
         dbo.tblZEGCode.ZEGCode,
         dbo.qryOtherFieldDataFieldName.FieldName
  FROM   dbo.qryOtherFieldDataVerifySource
         LEFT OUTER JOIN dbo.qryOtherFieldDataFieldName
           ON dbo.qryOtherFieldDataVerifySource.ItemID = dbo.qryOtherFieldDataFieldName.ItemID
         LEFT OUTER JOIN dbo.tblBC
                         RIGHT OUTER JOIN dbo.tblZEGCode
                           ON dbo.tblBC.BCID = dbo.tblZEGCode.BCID
           ON dbo.qryOtherFieldDataVerifySource.ZEGCodeID = dbo.tblZEGCode.ZEGCodeID 
  </code></pre>
  
  <p>Does anyone have any suggestions?</p>