{"id":2918,"date":"2019-03-25T17:41:49","date_gmt":"2019-03-25T20:41:49","guid":{"rendered":"http:\/\/xexeu.elipse.com.br\/pt\/kb49201-using-log10-function-and-caseelse-commands-in-an-sql-query\/"},"modified":"2025-09-23T15:00:31","modified_gmt":"2025-09-23T18:00:31","slug":"kb49201-using-log10-function-and-caseelse-commands-in-an-sql-query","status":"publish","type":"post","link":"https:\/\/kb.elipse.com.br\/en\/kb49201-using-log10-function-and-caseelse-commands-in-an-sql-query\/","title":{"rendered":"KB-49201: Using Log10 function and Case\/Else commands in an SQL query."},"content":{"rendered":"<div style=\"text-align: justify;\">\n<p><span style=\"font-weight: bold;\">Question:<\/span><\/p>\n<p>How can I have a Query&#8217;s <span style=\"font-style: italic;\">Log10 <\/span>function be executed only in rows different from 0 (zero), leaving rows equal to zero with value 0 (zero)?<\/p>\n<p><span style=\"font-weight: bold;\">Solution:<\/span><\/p>\n<p>To apply <span style=\"font-style: italic;\">Log10 <\/span>function only to rows that are different from 0 (zero), you must use <span style=\"font-family: Courier New; color: #000000;\">Case\/Else<\/span> commands inside an SQL query in order to test their values before you run the function. If the value is zero, the same value will be attributed to the field. If the value is different from zero, <span style=\"font-style: italic;\">Log10 <\/span>function will be applied.<\/p>\n<p>Example of SQL query performing this:<\/p>\n<div style=\"text-align: left;\"><span style=\"font-family: Courier New; color: #000000;\">SELECT CASE WHEN Field = 0 THEN 0 ELSE LOG10(Field) END AS Logarithm<\/span><br style=\"font-family: Courier New; color: #000000;\" \/><span style=\"font-family: Courier New; color: #000000;\">FROM table<\/span><\/div>\n<p><span style=\"font-weight: bold;\">NOTE<\/span>: This code is only valid for SQLServer databases.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Question: How can I have a Query&#8217;s Log10 function be executed only in rows different from 0 (zero), leaving rows equal to zero with value 0 (zero)? Solution: To apply&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0},"categories":[743],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>KB-49201: Using Log10 function and Case\/Else commands in an SQL query. - Elipse Knowledgebase<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kb.elipse.com.br\/kb49201-using-log10-function-and-caseelse-commands-in-an-sql-query\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"KB-49201: Using Log10 function and Case\/Else commands in an SQL query.\" \/>\n<meta property=\"og:description\" content=\"Question: How can I have a Query&#8217;s Log10 function be executed only in rows different from 0 (zero), leaving rows equal to zero with value 0 (zero)? Solution: To apply&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kb.elipse.com.br\/kb49201-using-log10-function-and-caseelse-commands-in-an-sql-query\/\" \/>\n<meta property=\"og:site_name\" content=\"Elipse Knowledgebase\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/elipsesoftware\" \/>\n<meta property=\"article:published_time\" content=\"2019-03-25T20:41:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-09-23T18:00:31+00:00\" \/>\n<meta name=\"author\" content=\"Elipse Software\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Elipse Software\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/kb.elipse.com.br\/kb49201-using-log10-function-and-caseelse-commands-in-an-sql-query\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/kb49201-using-log10-function-and-caseelse-commands-in-an-sql-query\/\"},\"author\":{\"name\":\"Elipse Software\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87\"},\"headline\":\"KB-49201: Using Log10 function and Case\/Else commands in an SQL query.\",\"datePublished\":\"2019-03-25T20:41:49+00:00\",\"dateModified\":\"2025-09-23T18:00:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/kb.elipse.com.br\/kb49201-using-log10-function-and-caseelse-commands-in-an-sql-query\/\"},\"wordCount\":126,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\"},\"articleSection\":[\"E3Query\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/kb.elipse.com.br\/kb49201-using-log10-function-and-caseelse-commands-in-an-sql-query\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/kb.elipse.com.br\/kb49201-using-log10-function-and-caseelse-commands-in-an-sql-query\/\",\"url\":\"https:\/\/kb.elipse.com.br\/kb49201-using-log10-function-and-caseelse-commands-in-an-sql-query\/\",\"name\":\"[:pt]KB-49201: Using Log10 function and Case\/Else commands in an SQL query.[:] - Elipse Knowledgebase\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#website\"},\"datePublished\":\"2019-03-25T20:41:49+00:00\",\"dateModified\":\"2025-09-23T18:00:31+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/kb.elipse.com.br\/kb49201-using-log10-function-and-caseelse-commands-in-an-sql-query\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/kb.elipse.com.br\/kb49201-using-log10-function-and-caseelse-commands-in-an-sql-query\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/kb.elipse.com.br\/kb49201-using-log10-function-and-caseelse-commands-in-an-sql-query\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\/\/kb.elipse.com.br\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"KB-49201: Using Log10 function and Case\/Else commands in an SQL query.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/kb.elipse.com.br\/#website\",\"url\":\"https:\/\/kb.elipse.com.br\/\",\"name\":\"Elipse Knowledgebase\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/kb.elipse.com.br\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\",\"name\":\"Elipse Software\",\"url\":\"https:\/\/kb.elipse.com.br\/\",\"sameAs\":[\"http:\/\/www.facebook.com\/elipsesoftware\"],\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png\",\"contentUrl\":\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png\",\"width\":161,\"height\":58,\"caption\":\"Elipse Software\"},\"image\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87\",\"name\":\"Elipse Software\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g\",\"caption\":\"Elipse Software\"},\"url\":\"https:\/\/kb.elipse.com.br\/en\/author\/webmasterelipse-com-br\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"KB-49201: Using Log10 function and Case\/Else commands in an SQL query. - Elipse Knowledgebase","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/kb.elipse.com.br\/kb49201-using-log10-function-and-caseelse-commands-in-an-sql-query\/","og_locale":"en_US","og_type":"article","og_title":"[:pt]KB-49201: Using Log10 function and Case\/Else commands in an SQL query.[:] - Elipse Knowledgebase","og_description":"Question: How can I have a Query&#8217;s Log10 function be executed only in rows different from 0 (zero), leaving rows equal to zero with value 0 (zero)? Solution: To apply&hellip;","og_url":"https:\/\/kb.elipse.com.br\/kb49201-using-log10-function-and-caseelse-commands-in-an-sql-query\/","og_site_name":"Elipse Knowledgebase","article_publisher":"http:\/\/www.facebook.com\/elipsesoftware","article_published_time":"2019-03-25T20:41:49+00:00","article_modified_time":"2025-09-23T18:00:31+00:00","author":"Elipse Software","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Elipse Software","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kb.elipse.com.br\/kb49201-using-log10-function-and-caseelse-commands-in-an-sql-query\/#article","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/kb49201-using-log10-function-and-caseelse-commands-in-an-sql-query\/"},"author":{"name":"Elipse Software","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87"},"headline":"KB-49201: Using Log10 function and Case\/Else commands in an SQL query.","datePublished":"2019-03-25T20:41:49+00:00","dateModified":"2025-09-23T18:00:31+00:00","mainEntityOfPage":{"@id":"https:\/\/kb.elipse.com.br\/kb49201-using-log10-function-and-caseelse-commands-in-an-sql-query\/"},"wordCount":126,"commentCount":0,"publisher":{"@id":"https:\/\/kb.elipse.com.br\/#organization"},"articleSection":["E3Query"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kb.elipse.com.br\/kb49201-using-log10-function-and-caseelse-commands-in-an-sql-query\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kb.elipse.com.br\/kb49201-using-log10-function-and-caseelse-commands-in-an-sql-query\/","url":"https:\/\/kb.elipse.com.br\/kb49201-using-log10-function-and-caseelse-commands-in-an-sql-query\/","name":"[:pt]KB-49201: Using Log10 function and Case\/Else commands in an SQL query.[:] - Elipse Knowledgebase","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/#website"},"datePublished":"2019-03-25T20:41:49+00:00","dateModified":"2025-09-23T18:00:31+00:00","breadcrumb":{"@id":"https:\/\/kb.elipse.com.br\/kb49201-using-log10-function-and-caseelse-commands-in-an-sql-query\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kb.elipse.com.br\/kb49201-using-log10-function-and-caseelse-commands-in-an-sql-query\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kb.elipse.com.br\/kb49201-using-log10-function-and-caseelse-commands-in-an-sql-query\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/kb.elipse.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"KB-49201: Using Log10 function and Case\/Else commands in an SQL query."}]},{"@type":"WebSite","@id":"https:\/\/kb.elipse.com.br\/#website","url":"https:\/\/kb.elipse.com.br\/","name":"Elipse Knowledgebase","description":"","publisher":{"@id":"https:\/\/kb.elipse.com.br\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kb.elipse.com.br\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/kb.elipse.com.br\/#organization","name":"Elipse Software","url":"https:\/\/kb.elipse.com.br\/","sameAs":["http:\/\/www.facebook.com\/elipsesoftware"],"logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/","url":"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png","contentUrl":"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png","width":161,"height":58,"caption":"Elipse Software"},"image":{"@id":"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87","name":"Elipse Software","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g","caption":"Elipse Software"},"url":"https:\/\/kb.elipse.com.br\/en\/author\/webmasterelipse-com-br\/"}]}},"_links":{"self":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/2918"}],"collection":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/comments?post=2918"}],"version-history":[{"count":1,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/2918\/revisions"}],"predecessor-version":[{"id":17257,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/2918\/revisions\/17257"}],"wp:attachment":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/media?parent=2918"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/categories?post=2918"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/tags?post=2918"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}