Δες μια δικιά μου sql που κάνει search:
Dim CommandText As String = "" & _
" (" & _
" (SELECT TOP 50 0 AS Type, dbo.Categories.ID , FT_TBL.Title AS Title, FT_TBL.Description, KEY_TBL.RANK FROM dbo.CategoryStrings FT_TBL INNER JOIN FREETEXTTABLE(CategoryStrings , *, '" & SearchString & "') KEY_TBL ON FT_TBL.ID = KEY_TBL.[KEY] INNER JOIN dbo.Categories ON FT_TBL.CategoryID = dbo.Categories.ID WHERE (FT_TBL.LanguageID = " & LanguageID & "))" & _
" UNION ALL " & _
" (SELECT TOP 50 1 AS Type, dbo.Products.ID , FT_TBL.Title AS Title, FT_TBL.Description, KEY_TBL.RANK FROM dbo.ProductStrings FT_TBL INNER JOIN FREETEXTTABLE(ProductStrings , *, '" & SearchString & "') KEY_TBL ON FT_TBL.ID = KEY_TBL.[KEY] INNER JOIN dbo.Products ON FT_TBL.ProductID = dbo.Products.ID WHERE (FT_TBL.LanguageID = " & LanguageID & "))" & _
" UNION ALL " & _
" (SELECT TOP 50 2 AS Type, dbo.Publications.ID, FT_TBL.Title AS Title, FT_TBL.Description, KEY_TBL.RANK FROM dbo.PublicationStrings FT_TBL INNER JOIN FREETEXTTABLE(PublicationStrings, *, '" & SearchString & "') KEY_TBL ON FT_TBL.ID = KEY_TBL.[KEY] INNER JOIN dbo.Publications ON FT_TBL.PublicationID = dbo.Publications.ID WHERE (FT_TBL.LanguageID = " & LanguageID & "))" & _
" )" & _
" ORDER BY rank DESC"
Τώρα για το ικανοποιητικό δεν ξέρω, αλλά μέσες άκρες κάνει ότι search κάνει και το google (πρέπει να πετύχεις ακριβώς το substring στα ελληνικά).
Χρήστος Γεωργακόπουλος