Cutter's Crossing

Comments (Comment Moderation is enabled. Your comment will not appear until approved.)

• #1 by dc on 2/9/07 - 5:46 AM

  

  For completeness, NVL(expr1, expr2) is Oracle equivalent.
  
  Also, COALESCE is a slighty different beast in Oracle... where you can put N number of expressions into it as arguments and it will return the first non null value.
  
  COALESCE(expr1, expr2, expr3, ..., exprN)

• #2 by Cutter on 2/9/07 - 6:29 AM

  

  Thanks dc, forgot to look at Oracle. Great addition. I think the COALESCE() works the same way in PostgreSQL as well, I just didn't linger on the documentation long enough for sure. The links to documentation that I put on the expressions above should clarify each individual function a little better.

• #3 by Eddie Lau on 5/24/07 - 9:45 PM

  

  For Microsoft Access, use Nz(.) function.

• #4 by Cutter on 5/28/07 - 9:47 AM

  

  Thanks Eddie. I tend to leave Access out of examples, because of it's lack of scalability, but it is good to let folks know. There are many developers who use Access as a learning tool or for extremely small, low traffic projects, so it good to have the information.