Is there a way to conditional CONCAT in the result. Lets say i have a First ,Middle and Last Name if i use First || " " || Middle || " " || Last as Name i will have an extra " " space if there is no Middle Name. So i hope there is a way to go specify to only insert space if there is a value

Conditional Concat with space

makeawish February 1, 2019, 11:32pm 5

Thanks that did the trick and also works if there is no middle_name or value is null in doc.

Topic		Replies	Views
Strange behavior when adding twho or more fields via \|\| SQL++	3	642	April 16, 2020
N1QL output format Question SQL++	5	1129	May 23, 2019
Replicate IFMISSINGORNULL in QueryBuilder Mobile	6	922	November 20, 2019
Simulate SQL Coalesce and ISNULL using N1ql SQL++	6	3656	May 4, 2018
How can I return a null or empty string if a key value does not exist? SQL++	1	1281	January 11, 2022