Is there a good way to swap the last value in a query row (Z to X)

[Pack10]

I have to change the last character of a value in a query column. The last character is a "Z", I need to change it to an "X". Is there a good way to do it.

 

[Pack10]

I mean all rows of the column....

 

[SkipVought]

Hi,

So this is a query?

What application?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Pack10]

Yes

 

[SkipVought]

The application is "yes?"

???

Are you looking for help?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}