Teradata ISNULL Alternatives

Raymond Raymond visibility 3,284 event 2020-09-08 access_time 4 years ago language English

In SQL Server, ISNULL function is commonly used to populate a value for null columns.  In Teradata, there is no ISNULL function but COALESCE and CASE WHEN can be used as alternatives. 

Use COALESCE function

SELECT COALESCE(NULL,'ABC','CDE');

Result:

ABC

Apply to a column or expression

SELECT COALESCE(Col1, Col2,'DEFAULT') FROM DatabaseName.TableName;

Use CASE WHEN statement

SELECT CASE WHEN Col IS NULL THEN 'DEFAULT' ELSE Col END FROM DatabaseName.TableName;

Remember to change database, table and column names accordingly. 

More from Kontext
info Last modified by Administrator 4 years ago copyright This page is subject to Site terms.
comment Comments
No comments yet.

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts