begin
if (@__filterwildcard = ”)
select v_Collection.CollectionID, v_Collection.Name from v_Collection order by v_Collection.Name
else
select v_Collection.CollectionID, v_Collection.Name from v_Collection
WHERE v_Collection.CollectionID like @__filterwildcard
order by v_Collection.Name
end 

 

Leave a Reply

Your email address will not be published. Required fields are marked *