I use the Copy as IN clause a lot and think it is one of the most helpful functions in SQL Prompt.

It would be even better if it could format the IN list according to the Style setting you have selected.

This is how it is created when right clicking on the function
ContractsId IN
(
234151,
234321,
239990,
228809,
240808,
231809,
240021,
230876,
231739,
239555,
240972
)

If I then use format SQL it changes it to the way I want it, without line brakes for each row but in relation to the other statement.

It would be nice if the formating of the right click function followed the Style setting for IN lists.

SELECT *
FROM tra.ContractDetailView
WHERE SourceSystemNo = 4
AND ContractsId IN (234151, 234321, 239990, 228809, 240808, 231809, 240021, 230876, 231739, 239555, 240972)