Thanks for your response. I have tried your suggestion in the past and I tried it again. I get the following exception:
java.sql.SQLException: [SQL0206] Column "'" not in specified tables. Cause . . . . . : "'" is not a column of table
In the data source step, we want to be able to run the following query,
select *
from aTable
where column1 = '777'
and column2 = 'B'
where the value for column2 (B) is read from a spreadsheet in an earlier step (${Properties#theProperty} ) and using the Dynamic Properties facilities of SoapUI, we want to add the single quotes around the value and hence the expression ${="'" + ${Properties#theProperty} + "'"}. Again, this works well if the ${Properties#theProperty} is a numeric.
Thanks,
Srini
