cancel
Showing results for 
Search instead for 
Did you mean: 

string_agg application

jbrotto
Active Contributor
0 Kudos
1,531

I am trying to aggregate some text from all my numAtCard fields would this function make sense?

string_agg

Accepted Solutions (1)

Accepted Solutions (1)

OlehFabri
Participant
0 Kudos

Hi Jonathan,

In the example below, the STRING_AGG function will retrieve all NumAtCard values from the ORDR table and concatenate them in a string with a comma separator between the values. NULL values will be ignored.

SELECT STRING_AGG(NumAtCard,',') AS NumAtCard FROM ORDR

Answers (0)