Raymond Raymond

Teradata ISNULL Alternatives

event 2020-09-08 visibility 4,586 comment 0 insights toc
more_vert
insights Stats

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
comment Comments
No comments yet.

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts