On 11/9/02 3:01 AM, "Bruno Batarelo" <[EMAIL PROTECTED]> wrote:
> Greetings
>
> I have problems executing very simple UPDATE query. I do not know whether it
> is a bug or not, but it works in Access and also works with mySQL, but only
> from access using linked tables.
> Query is as followes:
>
>
Greetings
I have problems executing very simple UPDATE query. I do not know whether it
is a bug or not, but it works in Access and also works with mySQL, but only
from access using linked tables.
Query is as followes:
UPDATE Table_name SET Field_name = Left(Field_name, 4) & 'a' &
Right(Field_name
