September 3, 2011 at 11:17 pm
Hi all,
Sorry if this is wrong place to write...
My question is ..
i do have a stored procedure which search text for me in a table.
Now i need an other stored procedure which show related search...just like google search do...."did you mean" etc etc OR search instead etc etc
How i can do this?
September 4, 2011 at 8:16 am
You could try to use FREETEXT search and see if it provides what you're looking for.
http://msdn.microsoft.com/en-us/library/ms187787%28v=SQL.90%29.aspx
September 5, 2011 at 12:10 am
Let me Explain what i want to do......
My Sp is given below
Create PROCEDURE [dbo].[searchTest]
@qry nvarchar(150)
AS
BEGIN
SELECT COMPANYNAME,
ADDRESS
FROM vwSearchResult
WHERE
comp_kws like '%' + @qry + '%'
END
===============
Now i want to show those COMPANYNAME which have more characters matched....like
if COMPANYNAME = 'abcd technology' and some one pass 'bcd'....then i want to select this COMPANYNAME...etc etc
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply