Hi All I have a table where it has 45000 Rows of data and a Column Named Description will be used to search
Just if user enters the Text like this *"Bailed out With"* Where i split the String and will build the Query String and Query will be like this Select * from CaseList where Description Like'%bailed%' or description like '%Out%' or description Like '%With%' This above Query Takes 15.6 Minutes to search data I think this can be solved by FullText Index search But i am using SQL Express...??? Can any one tell me what to do to search data very fast??? please let me know as soon as possible.. -- Thanks & Regards Avinash Desai *SAVE Nature SAVE Tree SAVE* Think Before you print: Please consider our environment before printing this e-mail Charles de Gaulle<http://www.brainyquote.com/quotes/authors/c/charles_de_gaulle.html> - "The better I get to know men, the more I find myself loving dogs."
