I've created a table with several fields, 3 of which are created using
these SQL statements:
[description] [varchar](255) NOT NULL DEFAULT ('') COLLATE NOCASE,
[keywords] [varchar](255) NOT NULL DEFAULT ('') COLLATE NOCASE,
[metadata] [varchar](255) NOT NULL DEFAULT ('') COLLATE NOCASE);
__________
Subsequent data insertions of empty strings produce the following data:
(null)|(null)|(null)
__________
It is important in the application this data is associated with to NOT
have any NULL fields. To me, an empty string is not a NULL, only an empty
string, an important distinction.
How can I prevent the insertion of NULLs into these fields and instead
replace them with empty strings?
Lee Crain
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
