Home Forums SQL Server 2008 T-SQL (SS2K8) Has to Be a Better Way RE: Has to Be a Better Way

  • January 14, 2013 at 2:34 am

    #1576794

    anthony.green (1/11/2013)

    Full text indexing would be an option using the contains clause

    SELECT ..... FROM SomeTable

    WHERE CONTAINS(ColumnName, 'abc or def or ghi ....... ')

    + 1

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)