Hello,
Can someone please help me construct a select statement where there could be multiple parameters that are sent to a SPROC?

I have a form with two calander controlls and two dropdown lists. The user should be able to select the datefrom-to-dateto and/or state and/or eventtitle.

The sproc should be able to process the select statement if the user only selects the state or the dates or the event title or all three.

Any help would be great!