Queries 06)

(‘A’,’B’,’C’) – Changes Data in Place For SQL Where Clauses

Generally used with alphanumeric fields in a SQL “Where” clause.

This will take the highlighted cell contents and wrap them into one string, surrounding in single quotes and placing a comma between each item.

It will place that string in the clipboard so that you can “Paste” it where needed.


Queries | Lists | Find | Alter | Clean | Sum | Functions | Help | Misc