I'm looking for a way to insert a default comment into a field if the user doesn't make their own entry, but I'm hoping to accomplish it in the table creation script. For example, ISNULL can be used to make some default entries, but it only works for varchar and not for text datatypes. Is there something that accoplishes this?
Otherwise, I'll just test for an entry and use php to make the entry that I want if they don't enter something themselves. But I'd really like to find something that works for text datatypes at table creation. Thanks.
