When your ORM does not support string concatenation by || or + operator…
Posted by jpluimers on 2020/09/30
If your ORM does not support string concatenation by operator (standard double pipe || or non-standard plus +), you can usually revert to the CONCAT function.
Very often, the CONCAT function supports more than 2 parameters.
References:
- [WayBack] operators – Why “||” is used as string concatenation in PostgreSQL/Redshift – Stack Overflow
- [WayBack] CONCAT (Transact-SQL) | Microsoft Docs
- [WayBack] + (String Concatenation) (Transact-SQL) | Microsoft Docs
- [WayBack] SQL Dialects Reference/Functions and expressions/String functions – Wikibooks, open books for an open world
–jeroen
The Wiert Corner - irregular stream of stuff 
Leave a comment