>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

Read article referenced in this message Re: Checking either / or of two fields for query Thread #1442422 Message #1442428