Is there any function in SQL which returns the number of matching words between parameter and data in database
-
hello, I want to sort the result of the search result according to the descending order of number of matching words in entered text and the particular record in a database. thank you.
yog hui gfgh kgdgrt njjn hjgkn
-
hello, I want to sort the result of the search result according to the descending order of number of matching words in entered text and the particular record in a database. thank you.
yog hui gfgh kgdgrt njjn hjgkn
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