Home Forums SQL Server 2008 T-SQL (SS2K8) Has to Be a Better Way RE: Has to Be a Better Way
Ant-Green
SSC Guru
Points: 113445
More actions
January 11, 2013 at 8:29 am
#1576342
Full text indexing would be an option using the contains clause
SELECT ..... FROM SomeTable
WHERE CONTAINS(ColumnName, 'abc or def or ghi ....... ')