TRIM(NVL(x, 'NULL')) IS NULL

1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #127,151 by ben_tilly 11/21/03 6:26:03 PM Reply	TRIM(NVL(x, 'NULL')) IS NULL Yes, it is wordy and ugly. But you come to expect that of SQL. And contrary to your assertion, nulls have a definite meaning and use in string data. I just wish that databases understood that empty strings also have their place. (In which case what you tried would have worked.) 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,156 by ChrisR 11/21/03 6:42:52 PM Reply	Why the NVL? Just futzing around on Oracle 9i, and the following seems sufficient: TRIM(x) IS NULL
Post #127,159 by ben_tilly 11/21/03 6:56:55 PM Reply	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	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

Do you believe everything you read on the radio?
38 ms