Re: size of char field with null
From: Svend Jensen <svend.jensen_at_it.dk>
Date: Tue, 11 Feb 2003 20:37:59 +0100
Message-ID: <3E495117.5070508_at_it.dk>
Date: Tue, 11 Feb 2003 20:37:59 +0100
Message-ID: <3E495117.5070508_at_it.dk>
Try,
select vsize(char_10_column) from table
where .... (char_10_column is null).....
/Svend
Anand wrote:
> Hi,
>
> This is a very fundamental kinda question.
>
> If i've a nullable char(10) field in a table, and insert a null value
> in it, will it occupy space or not? If it will, then how much space
> would that be?
>
> Thanks & Regards,
> Anand
Received on Tue Feb 11 2003 - 20:37:59 CET