SqlDbx Forum

barjan99

Member

Suggestion for copying data from grid results

There are many times when I copy text data to be used in another query.  It would be really helpful to have the option to add a comma after each entry so I can easily paste into an IN clause.

For example, when I currently copy the following

A
B
C

It pastes as
'A'
'B'
'C'

I would like to have the option to have it paste with commas at the end as in:
'A',
'B',
'C'

Even if that means I have to remove manually the comma from the last row, this feature would still be very useful.

Thanks, and keep up the great work with this product

sqldbxhelp

Administrator

Re: Suggestion for copying data from grid results

The option to generate IN clause already exists.
Select values in Results Grid, right click and select Generate->WHERE IN ()