> I've never had to do this until now and should > probably know the answer but > can the Default value shown for a column in a table > be an expression? If so > what is the syntax?
As I just discovered last week, no, a default value cannot be an expression. It must be a constant. To put a calculated default value into a column you must use an ON AFTER INSERT trigger. -- Larry
