So I'm working on an ASP page and I am making use some select statement. Now, I need to specify a where clause and make the only condition in there optional, i.e.:
SELECT * from table where Upper(name) LIKE "SID"
I want to make
where Upper(name) LIKE "SID"
optional here. That is if, I pass "SID", it does the where clause, other wise it just does a select.