Support ISO 9075 standard string concatenation - double pipe by rplaire

Active

Type:	Suggestion
ID:	259291
Opened:	2/20/2007 5:32:30 PM
Access Restriction:	Public

Workaround(s)

view

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.

Details (expand)

English

SQL Engine

Implement the ISO SQL standard 9075, feature ID E021-07 to support the double pipe as a string concatenation operator.

Faster Development

Improved Administration

Other (please provides details below)

Improved migration from other database platforms.

0 attachments

Posted by Microsoft on 12/13/2007 at 3:41 PM

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.

Best regards
Michael

Posted by rplaire on 12/13/2007 at 4:26 PM

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.

Posted by RTPritch on 5/1/2008 at 6:50 AM

This is needed so that one version of a SQL statements can be ported to different database platforms without change.