Re: Query Help 2

2003-12-19 Thread cktsoi
yes, just a typing mistakes~~ anyway, both of them work fine. "gerald_clark" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > DId I type that? > I meant 1,4 > I left it as substring because that was what he tried. > > ¿n©_ ¡E¢X ¡¸ wrote: > > >yes, it should work, but should not be

Re: Query Help 2

2003-12-18 Thread gerald_clark
DId I type that? I meant 1,4 I left it as substring because that was what he tried. ¿n©_ ¡E¢X ¡¸ wrote: 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 abou

Re: Query Help 2

2003-12-18 Thread ¿n©_ ¡E¢X ¡¸
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

Re: Query Help 2

2003-12-18 Thread gerald_clark
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

Query Help 2

2003-12-18 Thread Jeff McKeon
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 tabl