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

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Databases Forum / What I thought that he wanted...
Post #127,159
by ben_tilly
11/21/03 6:56:55 PM
Reply
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]
Post #127,171
by ChrisR
11/21/03 7:45:30 PM
Reply
New understood. thanks.
     Need Oracle "isBlank" boolean test - (tablizer) - (7) - Nov. 21, 2003, 06:08:27 PM EST
         Blank Strings are null? - (ChrisR) - (2) - Nov. 21, 2003, 06:20:37 PM EST
             Depends on what he means by a "blank string" - (ben_tilly) - (1) - Nov. 21, 2003, 06:27:40 PM EST
                 Empty strings is what I meant. :-) - (ChrisR) - Nov. 21, 2003, 06:32:28 PM EST
         TRIM(NVL(x, 'NULL')) IS NULL - (ben_tilly) - (3) - Nov. 21, 2003, 06:26:03 PM EST
             Why the NVL? - (ChrisR) - (2) - Nov. 21, 2003, 06:42:52 PM EST
                 What I thought that he wanted... - (ben_tilly) - (1) - Nov. 21, 2003, 06:56:55 PM EST
                     understood. thanks. -NT - (ChrisR) - Nov. 21, 2003, 07:45:30 PM EST

Running on an Atari 800 with two extra 16KB memory banks.
33 ms