Renald Buter wrote:
Odd, eh? But what's worse, the JOIN between this column and other columns *also* uses this truncated values and the result is bogus.
I wouldn't say odd, as you didn't specified any order I wouldn't rely on the order of the output. Try ordering things for what you want and you'll probably get the correct results.
I'm also not sure that ANSI SQL specifies any order in particular when no order is passed on the query...
--renato -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
