DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Snippets has posted 5883 posts at DZone. View Full User Profile

Conditional Null Check

03.25.2006
| 6761 views |
  • submit to reddit
        Conditional Null Check

--SQL: 
coalesce(field1, 0)
--ACCESS: 
iif(isnull(field1), 0, field1)
--ORACLE: 
coalesce(field1, 0)