[mssms] OT: Noob SQL Question (Conversion failed when converting the nvarchar value 'Not-Detected' to data type int.)

[Dzikowski, Michael]

I'm trying to get around this:


Error

Conversion failed when converting the nvarchar value 'Not-Detected' to data 
type int.


SELECT *
      ,[Netbios_Name0]
      ,[Description]
      ,[SettingType]
      ,[SettingDescriptionRID]
      ,[RuleNameRID]
      ,[CurrentValue]
      ,[ContributingRules]
  FROM [CM_CAS].[dbo].[v_CIComplianceStatusDetail]

  Where RuleNameRID = 'ID-d9a2c1c2-b45e-4d8e-971a-5ddef2720827'
  and
  CurrentValue <= 1024 and
  CurrentValue <> '%Not%' and
  CurrentValue <> 'NULL'


I just want to find all systems that have the Current Value <= 1024


I tried something that isn't working,

  CurrentValue <> '%Not%' and
  CurrentValue <> 'NULL'

Conversion failed when converting the nvarchar value 'Not-Detected' to data 
type int.

Is there a way to get around that?