{"id":85,"date":"2009-10-27T16:06:07","date_gmt":"2009-10-27T15:06:07","guid":{"rendered":"http:\/\/blog.rabihtawil.com\/?p=85"},"modified":"2009-10-27T16:06:07","modified_gmt":"2009-10-27T15:06:07","slug":"coalesce-another-isnull-method","status":"publish","type":"post","link":"http:\/\/www.raytawil.com\/?p=85","title":{"rendered":"Coalesce another IsNull method"},"content":{"rendered":"
\n
COALESCE ( expression [ ,...n ] )\n\n<\/strong><\/em><\/strong><\/em><\/pre>\n<\/blockquote>\n
Coalesce is Equivalent with<\/p>\n
CASE    WHEN (expression1 IS NOT NULL) THEN expression1    WHEN (expression2 IS NOT NULL) THEN expression2    …    ELSE expressionN END
\nEND<\/p><\/blockquote>\n
My little experiment with coalesce<\/p>\n
DECLARE @i VARCHAR(20)
\nDECLARE @exp2
\nSET @exp2 = NULL<\/p>\n
SET @i = null
\nSELECT COALESCE (@i + ‘ more;’, ‘It”s Null’) –result [It’s Null]
\nSELECT COALESCE (@i , ‘ more;’, ‘Stranger’) –result [ more;]
\nSELECT COALESCE (@i , @exp2, ‘Stranger’)  –result [Stranger]<\/p>\n
SET @i = ‘Something’
\nSELECT COALESCE (@i + ‘ more;’, ‘It”s Null’) –result [Something more;]
\nSELECT COALESCE (@i , ‘ more;’, ‘Stranger’) –result [Something]
\nSELECT COALESCE (@i , @exp2 , ‘Stranger’) –result [Something]<\/p><\/blockquote>\n
As you see if I use case and combine it with null function it\u2019ll need more than one line. Coalesce is very useful and helpful in above case.<\/p>\n","protected":false},"excerpt":{"rendered":"
COALESCE ( expression [ ,…n ] ) Coalesce is Equivalent with CASE WHEN (expression1 IS NOT NULL) THEN expression1 WHEN (expression2 IS NOT NULL) THEN expression2 … ELSE expressionN END END My little experiment with coalesce DECLARE @i VARCHAR(20) DECLARE @exp2 SET @exp2 = NULL SET @i = null SELECT COALESCE (@i + ‘ more;’, […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[110],"tags":[],"_links":{"self":[{"href":"http:\/\/www.raytawil.com\/index.php?rest_route=\/wp\/v2\/posts\/85"}],"collection":[{"href":"http:\/\/www.raytawil.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.raytawil.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.raytawil.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.raytawil.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=85"}],"version-history":[{"count":0,"href":"http:\/\/www.raytawil.com\/index.php?rest_route=\/wp\/v2\/posts\/85\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.raytawil.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=85"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.raytawil.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=85"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.raytawil.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=85"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}