Concatenation in SQL Query to Excel
I often use SQL Query to get data from Excel.
Last time I needed to read one column and add some prefix to each value.
'SQL Query' action uses 'MS Access' SQL notation for Excel, so I tried the following syntax options:
No luck, each time I get 'Syntax error: missing operator'
Does anyone know how to use concatenation in SQL Query to Excel?