I’m tying to create a query to combine multiple fields with concat_ws().
But I’m not sure how to proceed, since field data are stored in a single column in CFDB.
For example, I have a field Hour with a value of ‘7’, and a field Minute with a value of ’30’. I’d like to use concat_ws() to output ‘7:30’.
- The topic ‘Concatenate’ is closed to new replies.