Teradata case statement null

Which i do not want in my output. I expect the output as NULL. Please me some logic to get NULL value. When there is no matching result in the table. Register Log in. Search form Search. Welcome to the Teradata Forums. Read the guidelines on posting. But, Teradata does not support isnull function. Instead, you have to use an alternate method to replace null values. In this article, we will check what is isnull alternative in Teradata SQL with some examples.

Improve this answer. Rob Paller Rob Paller 7, 24 24 silver badges 23 23 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. END Clause is used to mark the end of the case statement and is usually followed by an alias name that is given to the field created by this CASE statement. Suppose we have two fields in the dataset, and we want to create a calculated metric to categorize the marks using a CASE statement.

Here we specify different conditionals under the WHEN Statement, based on what the result set is derived. If in case no conditional is met, the result set in else conditional is set.