Home Forums SQL Server 2008 T-SQL (SS2K8) where filter col <> 0 returns error, col > 0 works, col contains no 0 RE: where filter col <> 0 returns error, col > 0 works, col contains no 0

  • July 19, 2013 at 2:39 am

    #1633887

    You can remove the CONVERT part from the SELECT to get the (estimated) query plan. But that doesn't remove the incorrect value.

    You really should fix this incorrect value(s) first.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **