4.0.14 Its rather a general SQL question, I'll ask it as I'm using MySQL.
An converted table has field of type VarChar(6), containing alphanumeric chars. Is it possible to run a query to generate a unique key so this can be used for new record? regards ___________________________________________________________ALL-NEW Yahoo! Messenger - sooooo many all-new ways to express yourself http://uk.messenger.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]