Support ISO 9075 standard string concatenation - double pipe
The ISO SQL standard 9075, feature ID E021-07 covers string concatenation. The standard specifies this is a double pipe character sequence ('||'). SQL Server doesn't currently uphold this standard.
Upvotes: 54<=-=Dec 13 2007 3:41PM=-=>
Thanks for the feedback and the many votes. Note that while we do not use the standard syntax for it, we are providing equivalent functionality with the ‘+’ operator.
Nevertheless, we will look into it for a future release.
Thank you, Michael.
While I am familiar with the “+” operator for string concatenation, it is both non-standard, making writing SQL for SQL Server more burdensome, and overloaded, causing hard-to-find type-casting errors.
The double-pipe would be a great improvement in a number of scenarios. I appreciate your consideration of it for a future version.<=-=May 1 2008 6:50AM=-=>
This is needed so that one version of a SQL statements can be ported to different database platforms without change.