Alternate to Full Text Search in SQL server (Search for a string in a table)

The attached SQL query (SP) used to find the text (string) in an entire table. For this SP we need to pass the table name and the search string. Once we pass the table name and the search string to the SP, it starts searching the entire table and gives the result set according to

 
 
 
 
 
(2)
928 times
Add to favorites
Databases
11/21/2012
E-mail Twitter del.icio.us Digg Facebook