Options
Surround Highlighted values with quotes and commas
Fred1936
Posts: 2
Is there a way to surround highlighted values with quotes?
If I have a Select statement and I past in some values into an IN clause, I want to highlight the values and perform a function to surround them with quotes and add commas.
Select * from NameTable
Where Name IN (
Bob
Bill
Jim
)
So I want to highlight Bob Bill Jim and have them set to 'Bob', 'Bill', 'Jim'.
If I have a Select statement and I past in some values into an IN clause, I want to highlight the values and perform a function to surround them with quotes and add commas.
Select * from NameTable
Where Name IN (
Bob
Bill
Jim
)
So I want to highlight Bob Bill Jim and have them set to 'Bob', 'Bill', 'Jim'.
Comments
There's no way to currently do this in Prompt.
It does seem like a really good idea, and a popular one too. We had a similar request posted here (with a workaround until we can get this implemented) as well as a couple similar ones on our UserVoice forum here and here.
Please do add your vote to these requests as it helps us when we prioritize what we're going to be working on next and it'll also notify you as soon as we have a build to try with it in.
Hopefully we'll be able to implement something to help this case.
Thanks,
Aaron.