It also lets you do some string-concatenation tricks, like the one I posted. RE: where it executes, it'll run in whatever database you're currently in. Note that you could just do "exec @SQL", but ...

I'm using a DateTimePicker from which I store the formatted ("MM'/'dd'/'yyyy") value into strDataViewDate variable.<BR><BR>I have been using the query builder to select the fields from the database to ...