SQL Server double pipe string concatenation issue update

The request to bring the ANSI SQL standard double pipe (“||”) operator for string concatenation to SQL Server has gotten some response from MS.

It is mostly positive, seeing as I never harbored hope for it to make it into Katmai SQL Server 2008. “Michael” left it active and noted the large-ish number of votes for the issue. He mentions that SQL Server uses the “+” operator for string concatenation – yes, we know, and we loathe it. Everyone else uses the double pipe, except, as I’ve noted, MySql, which makes, with SQL Server, and interesting pair.

Vote now, if you haven’t, so we can hope for SQL Server 2008 SP1!

Filed under: Getting Data