# No implementation for MySQL's group\_concat() function as well as user-defined variable declaration
**URL:** https://community.dremio.com/t/no-implementation-for-mysqls-group-concat-function-as-well-as-user-defined-variable-declaration/815
**Category:** Uncategorized
**Created:** [February 27, 2018, 3:14pm UTC](https://community.dremio.com/t/no-implementation-for-mysqls-group-concat-function-as-well-as-user-defined-variable-declaration/815 "2018-02-27T15:14:10Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@akhalil](https://community.dremio.com/u/akhalil)
#### Post date: [February 27, 2018, 3:14pm UTC](https://community.dremio.com/t/no-implementation-for-mysqls-group-concat-function-as-well-as-user-defined-variable-declaration/815/1 "2018-02-27T15:14:11Z")
Hello everyone,
I am trying to build some SQL queries in Dremio and I couldn’t find an equivalent implementation of the MySQL’s group\_concat() function as well as the set @var user-defined variable declaration statement.
I do appreciate if anyone can provide me with some information about these two issues.
Thanks,
Amal
---
### Author:  [@Akuqk](https://community.dremio.com/u/Akuqk)
#### Post date: [August 26, 2021, 4:22pm UTC](https://community.dremio.com/t/no-implementation-for-mysqls-group-concat-function-as-well-as-user-defined-variable-declaration/815/2 "2021-08-26T16:22:35Z")
Any luck? I am looking for this too now
---
### Author:  [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)
#### Post date: [August 30, 2021, 7:50am UTC](https://community.dremio.com/t/no-implementation-for-mysqls-group-concat-function-as-well-as-user-defined-variable-declaration/815/3 "2021-08-30T07:50:03Z")
@Akuqk @akhalil Adding group\_concat() is an enhancement, no current ETA