Both expressions are of the string type |
Concatenation |
One expression is a string type and the other a
character |
Addition |
One expression is numeric and the other is a string |
Addition |
Both expressions are numeric |
Addition |
Either expression is NULL |
NULL is returned |
Both expressions are empty |
Integer subtype is returned |