format setting for "Copy as IN clause"
when I paste after "Copy as In clause", got contents like this:
IN
(
1, --comma at behind
2
)
I hope got this:
IN
(
1
,2 --comma at before
)
please provide option, thanks.
4
votes
![](https://secure.gravatar.com/avatar/307e850092f3f2f2dc3467253f0cafbd?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
-
Meilech commented
Voting same as @Jeff Humphreys to generate "IN(1,2,3,4,5,6,7)"
-
Jeff Humphreys commented
Voting for in general controlling the formatting of the IN generation. One I'd like is to generate "IN(1,2,3,4,5,6,7)" as a single line. I've generated ones that had 100+ options, for debugging and excluding a bunch of stuff trying to isolate that one oddball, the outlier. I don't need to see these individually, just to understand these are "other" values.