Hello Kath

I experienced similar problems when trying to do this.  In the end I resorted to a stored proc, and passing the parameters seemed to work just fine.