Home Forums SQL Server 2017 SQL Server 2017 - Development Query a Field and Ignore Commas and Periods in DB Value RE: Query a Field and Ignore Commas and Periods in DB Value

  • June 14, 2018 at 9:24 am

    #1994015

    you could try 
    where replace (column_name,',','')='Acme Products Inc'

    or look to have the DB changed to include a csoundex column or even

    where soundex (column_name) =soundex('Acme Products Inc')

    ***The first step is always the hardest *******