If Col1 contains the string "Hello" and Col2 is Null, what is the result of SELECT Col1 + Col2?

If Col1 contains the string "Hello" and Col2 is Null, what is the result of SELECT Col1 + Col2?

If Col1 contains the string "Hello" and Col2 is Null, what is the result of SELECT Col1 + Col2?



A) "Hello"
B) Error
C) Null
D) "HelloNull"

Answer: C) Null