at the time of creating column in table .use the below syntax.Name varchar(10) default 'text'

Set NULL 'Text';

Eg. Set NULL 'N/A';