November 8, 2002 at 4:39 pm
Is there a way to create a default value of EMPTY for a field? I do not want a field to be NULL but it doesn't necessarily have to have data in it. I know it may not make sense to do this but it would help me with an issue I'm having. Thanks.
November 8, 2002 at 6:32 pm
If the datatype is of the character types then you can have a default of '' or an empty string. Other types don't allow this like this.
November 9, 2002 at 8:23 pm
A fild with no data in it is just a null value. I don't think you can.
November 10, 2002 at 6:03 am
Actually the reply by Antares686 worked perfectly. If you put '' as the default value of the field (as long as it is a character type) then it inserts an empty string whichs makes sure that the field is never null. Thanks to both of you for replying.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply