Hi, If you can use stored procedure this way is a good sulotion CREATE PROCEDURE Search_ALLV -- Add the parameters for the stored procedure here (@SearchP nvarchar(50), AS BEGIN SET NOCOUNT ON; BEGIN TRY SELECT @SearchP = '%' + RTRIM(@SearchP) + '%' SELECT Title,Advisor,PhysicalProgress,RialProgress,Photo1,Photo2 FROM ALLV_View WHERE Advisor LIKE @SearchP ORDER BY Advisor END TRY BEGIN CATCH SELECT ERROR_PROCEDURE() AS ErrorProcedure; END CATCH END you can call this procedure by the words in entered text as an Argument GO