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
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
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
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
