I'm trying to make my query optionally accept a Datepart interval. It works as intended until I added in<BR><pre class="ip-ubbcode-code-pre">WHEN @Interval= 'NONE ...