Hayley Posted February 27, 2021 Report Share Posted February 27, 2021 Hi everyone, how can I concatenate fields that are not blank via SQL? Thanks in advance! Quote Link to comment Share on other sites More sharing options...
0 PotatoMato Posted February 27, 2021 Report Share Posted February 27, 2021 Hi @Hayley, you can try the SQL formula below. COALESCE( NULLIF([@field:FieldName],''), '') + COALESCE(' ' + NULLIF([@field:FieldName],''), '') + COALESCE(' ' + NULLIF([@field:FieldName] ,''), '') -PotatoMato Quote Link to comment Share on other sites More sharing options...
0 Kuroshi Posted March 31, 2021 Report Share Posted March 31, 2021 Hello, you can also refer to this article for more sql functions: https://howto.caspio.com/function-reference/ Quote Link to comment Share on other sites More sharing options...
0 NailDyanC Posted May 1, 2021 Report Share Posted May 1, 2021 Just to add the comments above, you may try to check these links as well for implementing SQL functions: https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/ https://howto.caspio.com/datapages/datapage-components/calculated-values/ Quote Link to comment Share on other sites More sharing options...
.thumb.jpg.35dcacd54218283aca1c4a6b34c7cb18.jpg)
Question
Hayley
Hi everyone, how can I concatenate fields that are not blank via SQL?
Thanks in advance!
Link to comment
Share on other sites
3 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.