Filter out non decimal values from query

• DerbyNeal

  Hall of Fame

  Points: 3854

  More actions

  September 30, 2011 at 5:38 am

  #390515

  Hi,

  I need to ignore non decimal values from my query. I know how to filter the 1-9 values i.e....

  DELETE from dbo.ImportStage1

  where

  Column_8 LIKE '%[^0-9]%'

  which obviously deletes values of 9, 16, 201 etc

  But how do I delete values with decimal places? i.e....

  9.4, 16.7, 201.95 etc

  Thanks in advance

• Phil Parkin

  SSC Guru

  Points: 246985

  More actions

  September 30, 2011 at 5:54 am

  #1388805

  This should work:

  DELETE from dbo.ImportStage1

  where

  Column_8 <> Floor(Column_8)

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel

• DerbyNeal

  Hall of Fame

  Points: 3854

  More actions

  September 30, 2011 at 7:41 am

  #1388852

  Many thanks Phil