how do I get rid of an A in a access field

[Guest]

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

 

[Dirk Goldgar]

"Stupid and can prove it."

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.

 

[Guest]

Thanks a lot this works great.

"Stupid and can prove it."

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)