It returns no rows, with no errors, when passing the parameter. I tried it also without the quotes and nothing changed. I may have to do as you suggested and make a local SQL copy but our SugarCRM database is pretty large and I was hoping to avoid the duplication.

Thanks for input Rob.