What's the best way to search a DB table using a stored procedure?

Question

Dear All,

I want to know what's the best way to search a DB table using a stored procedure (let's say text search)?

What are the points I should look at?

Let me know if you guys want more information.

Answer 1

This query will give you list of tables whose name matches to your keyword

SELECT name FROM sysobjects WHERE xtype = 'U' AND name LIKE '%keyword%'