Which SQL function is commonly used to concatenate two text fields into a single field?

• A. CONCAT statement
• B. GROUP BY
• C. ORDER BY
• D. SUBSTRING

Answer: (A)

Combining two text fields into one is done with a string-concatenation function. CONCAT takes two or more strings and returns them glued together as a single value. For example, SELECT CONCAT(first_name, ' ', last_name) AS full_name FROM employees; This creates one full_name field by joining the two parts with a space. In some databases you can also use the || operator or other syntax, but CONCAT is the common, portable approach. The other options do not perform concatenation: GROUP BY is for aggregating rows, ORDER BY sorts the results, and SUBSTRING extracts a portion of a string.