IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

New Why the NVL?
Just futzing around on Oracle 9i, and the following seems sufficient:

   TRIM(x) IS NULL
New What I thought that he wanted...
was a test for when a string was just a row of spaces.

In which case you DON'T want NULL to match, so we need to move NULLs to some string that won't be nulled by the TRIM.

Cheers,
Ben
"good ideas and bad code build communities, the other three combinations do not"
- [link|http://archives.real-time.com/pipermail/cocoon-devel/2000-October/003023.html|Stefano Mazzocchi]
New understood. thanks.
     Need Oracle "isBlank" boolean test - (tablizer) - (7)
         Blank Strings are null? - (ChrisR) - (2)
             Depends on what he means by a "blank string" - (ben_tilly) - (1)
                 Empty strings is what I meant. :-) - (ChrisR)
         TRIM(NVL(x, 'NULL')) IS NULL - (ben_tilly) - (3)
             Why the NVL? - (ChrisR) - (2)
                 What I thought that he wanted... - (ben_tilly) - (1)
                     understood. thanks. -NT - (ChrisR)

You say, "Williams, how can you get away with such political incorrectness?" It's easy. I'm a tenured professor, and I have diversified sources of income -- plus, I don't have much longer in this world.
39 ms