Hi! I am trying to do an inner join of two tables using a char(3) key. The field I am joining by contains integers with sometimes leading zeros. The inner join works when the field is a full 3 character field, with for example 566, but when it starts with a 0, it does not work anymore. Why is this? I would appreciate some help, thanx. /Camilla
______________________________________________________________________ This e-mail has been scanned for all viruses by Excedo MailScreen, powered by MessageLabs. Mailscreen stops both known and unkown viruses, visit: http://www.mailscreen.se ______________________________________________________________________ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
