Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 3 of 3 total

Sat, Apr 30 2016 3:46 PM	Permanent Link
Huseyin Aliz myBiss ApS	Hi All, Is it possible from dbisam latest to combine results of a query to a single line like: Usual result: First Second Third ... What i want First,Second,Third Thanks in advance, Regards, HÃ¼seyin A.
Sun, May 1 2016 5:50 AM	Permanent Link
Fernando Dias Team Elevate	HÃ¼seyin, Yes, there is the LIST function. The syntax is: LIST( <YourColumn> [,Delimiter] ) The LIST function concatenates all the values in <YourColumn> column into a single string value, using a delimiter to separate them. The default delimiter is "," but you can specify another one. Example: SELECT LIST(FirstName) FROM Customers -- Fernando Dias [Team Elevate]
Sun, May 1 2016 5:57 AM	Permanent Link
Huseyin Aliz myBiss ApS	Fernando, Works great, thanks Regards, HÃ¼seyin On 01-05-2016 11:50, Fernando Dias wrote: > HÃ¼seyin, > > Yes, there is the LIST function. > The syntax is: > > LIST( <YourColumn> [,Delimiter] ) > > The LIST function concatenates all the values in <YourColumn> column > into a single string value, using a delimiter to separate them. > The default delimiter is "," but you can specify another one. > > Example: > SELECT LIST(FirstName) FROM Customers > > -- > Fernando Dias > [Team Elevate]