"miracles are for the ignorant, the poor, and the dying."
coalesce
co·a·lesce
ˌkōəˈles/
verb
come together and form one mass or whole.
"the puddles had coalesced into shallow streams"
combine (elements) in a mass or whole.
"to help coalesce the community, they established an office"
Choose language Afrikaans Albanian Amharic Arabic Armenian Azerbaijani Basque Belarusian Bengali Bosnian Bulgarian Burmese Catalan Cebuano Chinese (Simplified) Chinese (Traditional) Corsican Croatian Czech Danish Dutch Esperanto Estonian Filipino Finnish French Galician Georgian German Greek Gujarati Haitian Creole Hausa Hawaiian Hebrew Hindi Hmong Hungarian Icelandic Igbo Indonesian Irish Italian Japanese Javanese Kannada Kazakh Khmer Korean Kurdish Kyrgyz Lao Latin Latvian Lithuanian Luxembourgish Macedonian Malagasy Malay Malayalam Maltese Maori Marathi Mongolian Nepali Norwegian Nyanja Pashto Persian Polish Portuguese Punjabi Romanian Russian Samoan Scottish Gaelic Serbian Shona Sindhi Sinhala Slovak Slovenian Somali Spanish Sundanese Swahili Swedish Tajik Tamil Telugu Thai Turkish Ukrainian Urdu Uzbek Vietnamese Welsh Western Frisian Xhosa Yiddish Yoruba Zulu
Translations, word origin, and more definitions
https://msdn.microsoft.com/en-us/.../ms190349.aspx
Microsoft Developer Network
The COALESCE expression is a syntactic shortcut for the CASE expression. That is, the code COALESCE (expression1,...n) is rewritten by the query optimizer as ...