Ovid writes: > Other points aside, MySQL should default to 'strict' mode and by > default be as ANSI compliant as possible. As with so many things in MySQL, strict mode is subject to what Smylers refers to as the "version N+1 problem": it was introduced in MySQL 5.0, which not all shops can easily upgrade to. -- Aaron Crane