BuyLog In
Breaking Change T1092749
Visible to All Users

The Concat function now treats "null" ("Nothing") values as empty strings

What Changed

The Concat function (merges its parameters into a single string) available in the CriteriaCompiler and ExpressionEvaluator classes converts "null" arguments to empty strings. This change only affects client-side calculations.

Previous Behavior

If any of the Concat function's parameters is "null", the function returns "null".

Reasons for Change

The previous behavior differs from other implementations of similar functions in other products (for example, the Microsoft's Concat function in MSSqlServer or the standard String.Concat method). In addition, we received a significant number of Support Center tickets where customers reported the previous behavior as unexpected and confusing.

Impact on Existing Apps

Your apps should not be affected by this change.

How to Revert to the Previous Behavior

Generally, you should not revert to the previous behavior. In case of a rare, unique scenario where you wish to get "null" when Concat accepts a "null" parameter, contact our Support Center for a solution.

Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.