How can I convert the Set of Id's so that I can use this set into the Dynamic SOQL query that I want to use it with IN Comparison.

Hi Mohit,

Bind variables actually work in dynamic SOQL:

Map<Id,Account> accts = new Map<Id,Account>([select Id from Account]);
Set<Id> accountIds = accts.keySet();
String q = ‘select id from Contact where AccountId in :accountIds’;
List<Contact> cts = Database.query(q);

You can try the above code as an example.

Note that you can’t embed method calls (e.g. AccountId in :accts.keySet() would fail) when binding in this way.

Hope this helps you.

Thanks