Add a character within text field

  • Thread starter Thread starter P Brainard via AccessMonster.com
  • Start date Start date
P

P Brainard via AccessMonster.com

I need to develop a query that will add the 0 character as the second to the last character in every record in a column.

For example:

55003 - 550003
49443 - 494403
30421 - 304201
11111 - 111101
23232 - 232302

I know how to run one to append something to the end of the string, but not put it inside the string. Thanks for your help.
 
something like...

Left([somefield],10) & "0" & Right([somefield,1)


Hope that helps,

Rick B

P Brainard via AccessMonster.com said:
I need to develop a query that will add the 0 character as the second to
Click to expand...
the last character in every record in a column.
For example:

55003 - 550003
49443 - 494403
30421 - 304201
11111 - 111101
23232 - 232302

I know how to run one to append something to the end of the string, but
Click to expand...
not put it inside the string. Thanks for your help.
 
Left(SomeField,Len(SomeField)-1) & "0" & Right(SomeField,1)

That expression should work AS LONG AS the field is at least 2 Characters in length.
 
Back
Top