Viewing post 1 (of 1 total)
Try this:
select *
from tblparticipants
where varCategory = isnull(@varCategory, varCategory)
If the parm is null, the value from the current row is used, which will in effect just ignore null
July 19, 2005 at 7:14 am
#575460