The above suggestions helped out a great deal. I am able to get the results I need.

Thanks!

I apologize for the vague and incomplete information. The information, provided so far, may be exactly what I'm looking for. I'll try the suggested queries when I get to the...

Thanks john!

Hi Sushila,

Sort off.. I really just want to tack on the 'au_id = @au_id' if @au_id is not null or blank.

I will try the suggestions everyone offered, tomorrow, when I...

Sergiy,

I'll try that when I get back to the office tomorrow.

Thanks!

I think I left out some important criteria..

If the parameter is NULL or blank, I don't want to include it in the WHERE clause.

If it's not null, then I...