How do I replace one occurrence of a character in a text filed with another character

[Clint!]

Thanks again Orange, but how would I define my table name (NAFT-txt) in this Function?

[orange]

Tell us what you are trying to do in plain English. What is NAFT-txt?

You call the function and pass your "number" as a parameter.

eg: ASC_EBCD("-6552")


SELECT yourOrigField
, ASC_EBCD(yourOrigField) as RevisedNumber
from yourTable


Are you trying to create/run a query, or ???

Here's a sample from some data I had.
Query SQL showing use of ASC_EBCD

SELECT ClaimInfo.ClaimRef
, ASC_EBCD([claimref]) AS Revised
FROM ClaimInfo;

Output from my data

ClaimRef
Revised

20120919000538
2012091900053H

20120919000546
2012091900054F

20120919000949
2012091900094I

20120919000957
2012091900095G

20120919000967
2012091900096G

5723224
572322D

5721436
572143F

5720596
572059F

5720540
572054{

5722408
572240H

[Clint!]

Thanks orange, and I truly appreciate the time you put into this. I am a Novice with some training in VBA, but how would I define my field and table ([NAF-TXT].[AMT]) into this code?

[orange]

I updated my last post with an example