Never been to DZone Snippets before?

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

Conditional Null Check (See related posts)

Conditional Null Check

--SQL: 
coalesce(field1, 0)
--ACCESS: 
iif(isnull(field1), 0, field1)
--ORACLE: 
coalesce(field1, 0)
to sql null by codeguy on Sat Mar 25 14:01:29 -0500 2006

You need to create an account or log in to post comments to this site.


Click here to browse all 5140 code snippets

Related Posts