Home Forums SQL Server 2017 SQL Server 2017 - Development Find a string with two dots RE: Find a string with two dots

  • January 2, 2018 at 7:15 am

    #1974057

    tapasyagupta7 - Tuesday, January 2, 2018 7:06 AM

    Why not try

    WHERE Column1 not like '%.%'

    this will filter one dot or more

    Thanks

    Which would, also, filter out any values that have a decimal point. Such as 1.1. Thus, you only end up with the rows that have integer values; this is not what the OP is after.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk