How to concatenate an array of numbers without for loop

Hi, I have an array of integer numbers A = [1, 2, 3]. I would like to concatenate the numbers for use in SQL statement like '(1, 2, 3)'. How to do that without a for loop? Thanks.

Answer 1

[Stephen23]

>> A = [1,2,3];
>> str = sprintf(', %d',A);
>> str = sprintf('(%s)',str(3:end))
str = (1, 2, 3)

Answer 2

[Guillaume]

A = [1 2 3];
sprintf('(%s)', strjoin(compose('%d', A), ', '))

[JFz]

Thanks. Got an error Undefined function or variable 'compose'.

[Guillaume]

compose was introduced in version R2016b. (You should say in your question if you're several versions behind).

In earlier versions, you can replace compose by the undocumented sprintfc:

sprintf('(%s)', strjoin(sprintfc('%d', A), ', '));

Or use Stephen's method of using sprintf then removing the initial ', '.

[JFz]

Thanks!