Ok let me check your code.

Actually my case is....

i have a table have thousands of data about company and people do search for any company.

i want to provide related/suggested search...

Let me Explain what i want to do......

My Sp is given below

Create PROCEDURE [dbo].[searchTest]

@qry nvarchar(150)

AS

BEGIN

SELECT COMPANYNAME,

...