>I would like to try to use vfp to create a simple web search page that queries data on our mssql server. The user would just input a key word, and I'd like all the associated records spit back. I'd like to do it as simple as possible.. Can anyone point me in the right direction?

An alternative method to Paul's would be to use ASP to query the SQL Server directly and not use VFP. This would be the simplest route (maybe not the best though). From what I understand though (and what I have experienced) is that ASP becomes unwieldy when an application moves from simple to more complex.

Just a thought...