[thelist] Site Review Please

Rudy_Limeback at maritimelife.ca Rudy_Limeback at maritimelife.ca
Mon Sep 18 16:47:06 CDT 2000


> I'm easy, but I'm not cheap


oh hell... in for a penny, in for a pound....

  "i'm not cheap, but this week i'm on special!!"

or

  "i may not be perfect, but parts of me are excellent!!"


definitely gotta start paying for these....


<tip>
use the sql COALESCE function to ensure a non-null value

example:
 
   SELECT "Dear "||COALESCE(preferred_name, first_name, "Sir or Madam")
     FROM yourTable

COALESCE will return the first non-null value in its list, so you can set 
up a cascade of column or literal references in the preferred order

in oracle, the NVL function replaces COALESCE, and i think it only takes 
two arguments, so i'm not sure how you would do three....   adam?
</tip>


rudy
r937.com




More information about the thelist mailing list