yes, it should work, but should not be 1,1 ? or simply:
UPDATE RemoteStation SET company=LEFT(ID, 4); ? "gerald_clark" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > How about: > update RemoteStation set company=substring(ID,1,1); > > Jeff McKeon wrote: > > >Damn fat fingers and MS Outlook. I sent the "Query Help" message before > >I was finishes typing. Sorry... > > > >I have two tables, customer table and a company table > > > >The customer table has an ID field that is 8 characters long. The first > >4 characters are the company code. > > > >We just added a company table that has an id field that contains that > >companies id code. We also added a field to the customer table that > >will hold the company ID that the customer belongs to. So..... > > > >Customer table > > > >ID name company > >12347771 joe null > >12347772 mary null > >43210001 bob null > > > >Company Table > > > >ID name > >1234 Acme > >4321 Acme_Europe > > > >What I now need to do is create an update statement that will match the > >customer to the company by substring(Customer.ID,1,4) to Company.ID > > > >I tried: > > > >update RemoteStation set Company_ID=Company.ID where > >substring(Company_ID,1,4) like Company.ID; > > > >But it didn't work. Any suggestions? > > > >Thanks for the help, > > > >Jeff > > > > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]