Hi Terry,

How do I escape the single quotes in the filter conditions 'is any of'?

I am trying to filter a query by soptype however the qeury yields no results as the tsql statement being passed through is:

select [SOP10100].SOPTYPE AS 'SOP Type',

[SOP10100].[SOPNUMBE] AS 'SOP Number',

[SOP10100].[DOCID] AS 'Document ID' from TWO..[SOP10100] where ([SOP10100].SOPTYPE) in '2,3'

any value typed in is treated as a string