I have a stored proc which is used to perform a search - so some parameters get passed in that may or may not be NULL. How do I call this stored proc , specifying the nulls??
e.g.
Retrievalprocedures.Dosearch (System.DBNUll.Value, System.DBNULL.Value) - doesn't seem to work...
In the proc my where clause basically checks for nulls and replaces with its value e.g...
WHERE Postcode = ISNULL(@postcode, Postcode)
