Thank you that worked.

Thank you. I am not trying to write a unit test. I would to just execute the code for a someone that does testing. So they can verify it works as expected. Is there way to do that without a unit test?

@RubenDG Thanks. Im not trying to write a test class. I already have that. Let me clarify. We are doing regression testing. So a non technical person wants the job to run to test out the functionality is working. We do not want to wait till 1am when is scheduled to run to verify it before we move it to production. Does that make sense?

@LironC Thanks. I thought so. Was hoping there might be other strategy's people have done.

I expect just to see the single quotes only outputted. I don't know how else to explain it. The results are not showing any single quotes at all Example if have string of id i get this ('46734'.|'3435'). What I am looking for if no Ids then literally this ('') or (''|'')

Thanks .This didn't work for me either. Im just for just singles quotes and nothing inbetween the single quotes if there is no Id.

Let me rephrase. What i am looking for is if no records are returned I want to insert '' or ('').

it did not work.