Perhaps someone can help me with this. I'm not thinking to clear today.
I have a SELECT statement with a WHERE of something like:
WHERE &cWhere
Obviousely, this works fine if cWhere has a value. Can someone tell me how to deal with this if cWhere is empty. I assume you would use IIF() but can't figure out the code.