Re: LTRIM/RTRIM returning NULL
From: Guido Konsolke <Guido.Konsolke_at_triaton.com>
Date: Fri, 7 Feb 2003 15:24:24 +0100
Message-ID: <1044627701.187703_at_news.thyssen.com>
Date: Fri, 7 Feb 2003 15:24:24 +0100
Message-ID: <1044627701.187703_at_news.thyssen.com>
"Vattekkat Satheesh Babu" wrote...
> Folks,
>
> Anyone knows the rational behind LTRIM(' ') or RTRIM(' ')
> returning NULLs instead of blank strings ''?
>
> Curious
>
> - Babu
> http://vsbabu.org/
Hi Babu,
sorry, but RTFM!!!
In Oracle, at least until now, empty strings are NULL.
So, the functions work as they should. It is said
that this behaviour will change in coming versions.
Greetings,
Guido
Received on Fri Feb 07 2003 - 15:24:24 CET