Re: empty (not null) field values

hi,

well not that i know of. but look that this:

create or replace function isEmpty(value IN varchar2) return boolean
is
begin

        return ((value = 0) OR (length(ltrim(rtrim(value))) is null)); end;

I think this should serve as a good starting point to further customize this user-defined function to meet your specifice needs.

hope that helps.

:) ATTA In article <8a7qja$5i4$1_at_nnrp1.deja.com>,   rremus_at_yahoo.com wrote:
> Hi,
> Is there a function to test for empty values in fields, disregarding
> the data type of the field? By 'empty values' I mean the empty string
> (spaces or tabs) for characters, 0 for numerics etc.
> TIA,
> Remus
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

--

getting the meanin' of data...

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Mar 09 2000 - 04:05:50 CST