> FYI, "" does NOT equal NULL does not equal 0.
Interesting, I noticed that a few days ago. I noticed that in pg sql, if I
used RTRIM on a column with all blanks. the RTRIM'ed result is not null. In
Oracle I think it would be a null. That is in Oracle "" and NULL are
equivalent.
Vincent Hikida,
Member of Technical Staff - Urbana Software, Inc.
"A Personalized Learning Experience"
www.UrbanaSoft.com