My access 2000 database has a field {NUMBER} that contains following example:

R8175EQTA
86A160ZA
AG4200A
MILT81772TYPE3A

I want to eliminate the trailing "A" only.

Can anyone help????

"Stupid and can prove it."
<(E-Mail Removed)> wrote in message
news:F66FBA34-5213-49DD-B2AC-(E-Mail Removed)
> My access 2000 database has a field {NUMBER} that contains following
> example:
>
> R8175EQTA
> 86A160ZA
> AG4200A
> MILT81772TYPE3A
>
> I want to eliminate the trailing "A" only.
>
> Can anyone help????

You could execute an update query with SQL like this:

UPDATE [YourTableName]
SET [Number] = Left([Number], Len([Number]) -1)
WHERE [Number] Like "*A";

That's "air SQL", of course, but something along those lines should
work.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Thanks a lot this works great.

"Dirk Goldgar" wrote:

> "Stupid and can prove it."
> <(E-Mail Removed)> wrote in message
> news:F66FBA34-5213-49DD-B2AC-(E-Mail Removed)
> > My access 2000 database has a field {NUMBER} that contains following
> > example:
> >
> > R8175EQTA
> > 86A160ZA
> > AG4200A
> > MILT81772TYPE3A
> >
> > I want to eliminate the trailing "A" only.
> >
> > Can anyone help????
>
> You could execute an update query with SQL like this:
>
> UPDATE [YourTableName]
> SET [Number] = Left([Number], Len([Number]) -1)
> WHERE [Number] Like "*A";
>
> That's "air SQL", of course, but something along those lines should
> work.
>
> --
> Dirk Goldgar, MS Access MVP
> www.datagnostics.com
>
> (please reply to the newsgroup)
>
>
>