Parser to Convert User Search to Full Text

22 Oct 2005 6:57 AM

Will

Is there a parser with source code available that would allow a user to
enter a Google-like syntax for searches and then translate that to SQL
Server full text search syntax? I'm not too picky about the language
being used, but I'm more concerned about the robustness of the parser,
ability to defend against someone inserting SQL into the search stream, and
the ability to allow the user to build complex keyword-like searches and map
those to the correct syntax for SQL Server full text searches.

--
Will

23 Oct 2005 1:56 AM

John Kane

Will,
See the attached zip file (SQL_FTS_Parse_like_Google.zip) as it should come
close to what you're looking for.

Regards,
John

--
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/

Show quote

"Will" <westes-usc@noemail.nospam> wrote in message
news:OyXWfWt1FHA.2964@TK2MSFTNGP09.phx.gbl...
> Is there a parser with source code available that would allow a user to
> enter a Google-like syntax for searches and then translate that to SQL
> Server full text search syntax? I'm not too picky about the language
> being used, but I'm more concerned about the robustness of the parser,
> ability to defend against someone inserting SQL into the search stream,
> and
> the ability to allow the user to build complex keyword-like searches and
> map
> those to the correct syntax for SQL Server full text searches.
>
> --
> Will
>
>

[attached file: SQL_FTS_Parse_like_Google.zip]