Hi,
The question is more about SQL Server.. but.. maybe someone help :)

I have a stored procedure which return resultset..
As interface I have search string which must provide fulltext search... in the code I build WHERE rule from search string and want to pass it to stored procedure..
Can anyone show me example is it possible to use sp parameter
AS
@wherestatement STRING in the stored procedure

Of course I can build the SQLExpression in my code and then using sqlcommand return resultset. but way with stored procedure helps me to bind storedprocedure resultset to Linq class and Linq class - bind to the datasource of the grid.

Thanks for help

Denis