ExamGecko
Question list
Search
Search

Question 68 - TDS-C01 discussion

Report
Export

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

A.
True
Answers
A.
True
B.
False
Answers
B.
False
Suggested 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!

asked 23/09/2024
Thomas Kringel
37 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first