Hi,
Not sure what you're trying to achieve,
Are you trying to have a blank(' ') instead of '0'?
or are you trying to actually store as 'NULL'?
Have you tried
create table table_name (
field datatype(size) default as 'NULL',
...
)
?
--- "NIPP, SCOTT V (SBCSI)" <[EMAIL PROTECTED]> wrote:
> I am having a problem in that if a field is blank,
> it is getting
> put into the database as a '0' rather than 'NULL'.
> The table is setup
> to both allow NULL values in this field as well as
> NULL being the
> default value. The problem is that on a few entries
> the field is
> actually empty, but the database is entering the
> value into the table as
> a '0' as mentioned above. Does this problem sound
> familiar to anyone?
>
> Scott Nipp
> Phone: (214) 858-1289
> E-mail: [EMAIL PROTECTED]
> Web: http:\\ldsa.sbcld.sbc.com
>
>
>
