The following comment was submitted to the MySQL Manual. --------------------------------------------------------------------- From: Ilia Lobsanov <[EMAIL PROTECTED]> Regarding: http://www.mysql.com/manual.php?section=CREATE_TABLE Would be nice if the DEFAULT parameter accepted a logical statement. eg. ...column varchar(48) not null default substring_index(another_column, '.', 1); -- --------------------------------------------------------------------- Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php