Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 3 of 3 total |
Result of SQL in one line |
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] |
This web page was last updated on Friday, March 29, 2024 at 03:30 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |