Both expressions are of the string, date, character, boolean type |
Multiplication |
One expression is a string type and the other a
character |
Multiplication |
One expression is numeric and the other is a string |
Multiplication |
Both expressions are numeric |
Multiplication |
Either expression is NULL |
NULL is returned |
Both expressions are empty |
Empty string is returned |