• Services
    • Roles
    • Business Intelligence
    • Migration, Implementation and Training
  • Blog
    • Archives
  • About
  • Partners
  • Contact

Call us toll free 0800 1800 900

Find us on Map
rt@cpa-it.com
Login

Login
White-Knuckle Consulting White-Knuckle Consulting
  • Services
    • Roles
    • Business Intelligence
    • Migration, Implementation and Training
  • Blog
    • Archives
  • About
  • Partners
  • Contact

CONCAT() function advantages

Sep 2, 2015 | BI |

Why should you use the new CONCAT() function?   2 good reasons:

  1. When using the CONCAT() function, non string datatype arguments can be included and are implicitly converted to a string datatype.   Using the traditional “+” to concatenate fields, all of the fields concatenated needed to be of the same data type.   Using the concatenate function reduces coding time as there is no need to convert datatypes.
  2. The CONCAT() function automatically handles NULL values.  If a concatenated field contains NULL, the function substitutes and empty string of type varchar (1).

The CONCAT function was introduced in SQL Server 2012.

Share

Leave a Reply

Your email is safe with us.
Cancel Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Contact Us

Let us know how we can help you, and we will get back to you asap!

Send Message

© 2023 · White-Knuckle Consulting, LLC

  • D365 for Finance and Operations / Dynamics AX consulting – White-Knuckle Consulting
  • About Us
  • Services
  • Blog
  • Contact
Prev Next