Serach for a particular string in different columns in a table

• Trybbe

  Hall of Fame

  Points: 3967

  More actions

  January 8, 2013 at 1:47 am

  #287257

  Hi,

  is there a simpler way to search for a partcular string in different columns in a table. currently I have the following case statement. it's working fine but I was wondering if there is another way to do it?

  case

  when

  tbl_Name.Col_1=1

  or

  tbl_Name.Col_2 like '%MyString%'

  Or

  tbl_Name.Col_3 like '%MyString%'

  or

  tbl_Name.Col_4 like '%MyString%'

  or

  tbl_Name.Col_5 like '%MyString%'

  Then 1

  else 0

  End

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  January 8, 2013 at 2:03 am

  #1574670

  Have you tried Full Text Indexing?

  John

• Trybbe

  Hall of Fame

  Points: 3967

  More actions

  January 8, 2013 at 2:04 am

  #1574672

  I have never used it before may you please post example

• Dung Dinh

  SSCrazy

  Points: 2513

  More actions

  January 8, 2013 at 2:12 am

  #1574673

  - You can create a computed column and search on it

  Or

  - Try to do that with Full-Text Search

  http://msdn.microsoft.com/en-us/library/ms142571.aspx