Post reply

Filter out non decimal values from query

  • 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

  • September 30, 2011 at 5:54 am

    #1388805

    This should work:

    DELETE from dbo.ImportStage1

    where

    Column_8 <> Floor(Column_8)

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • September 30, 2011 at 7:41 am

    #1388852

    Many thanks Phil

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply