[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