Dave Blake wrote: > It seems that it is not possible to specify the concatenation separator > when using GROUP_CONCAT with DISTINCT.
The documentation <http://www.sqlite.org/lang_aggfunc.html> says: | In any aggregate function that takes a single argument, that argument | can be preceded by the keyword DISTINCT. > Is there another way I can specify the separator when using DISTINCT? If your values do not contain commas, you can use replace() afterwards. Otherwise, use a subquery with DISTINCT first, and then run the group_concat() over that. Regars, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users