___________the matched pairs would be retained, and any unmatched values in the other table would be left null.

What is information?

To get the year, quarter, month, week, day from a date value, you use the _____________ function.

____________function returns the number of characters in the string.

_________which is used to join a table with itself.

Concatenates data from two different character columns and returns a single column.

_____________convert a value of one data type into another

Ensures that a column will not have duplicate values

Returns the number of characters in a string value