True or False: To concatenate fields, they must be of same data type

True or False: To concatenate fields, they must be of same data type
A . True
B . False

View Answer

Answer: A

Explanation:

Yes! To concatenate fields, they must be of same data type. However, there is a workaround which we can use – Type casting. See below:

Here, State and City are Strings, but Postal Code? Nope. It’s an Integer. So we can simply use the STR() function to convert it into a String, and hence the entire equation becomes valid!