Report validation script

I'm trying to create a report for IT Shop requests to be used by application managers. Since we have  > 30 000 products and no logical grouping parameters, i have just writtens this in the sql query:

WHERE pwo.DisplayOrg LIKE '%' + @Displayorg + '%'

In order to not let the users be able to leave the user prompted paramter empty, i want to somehow have a condition or value calculation to replace a nothing value. I'm not gluent in VB.Net, so are there anyone who have any ideas as to how do this, or other suggestions?

Parents Reply Children