Optional Parameter in a SQL Function -- selecting all

[dantebothermy]

Hi, I need some help.

I have a function with a parameter that runs a query. I'd like the parameter to be optional, so that if the user enters nothing or "all" the query will select all records.

Is there something I can do to my WHERE clause so that it will select all records based on the value of my parameter?


(Actually, the real function has three parameters, but the issue is easier to explain as if there's only one.)

I'm baffled. Thanks a lot,


Dante

[ck9663]

Assign NULL as the default value to your parameter. Use this technique on your WHERE clause

SELECT...FROM...
WHERE yourfiltercolumn = isnull(@parameter, yourfiltercolumn)

-- CK

[dantebothermy]

Thanks CK! It worked