How do I insert a character in between a string in Access?

P

Pawan

I have Access databse with 250 records. In one of the columns I want to
insert a single character in between a string in all 250 records. e.g. I have
"A1400" in one record and I want to make it "AI1400" , I have "P2566" and I
want to make it "PI2566". It will be better if it is done using query. Is
there any solution?
 
R

Rick Brandt

Pawan said:
I have Access databse with 250 records. In one of the columns I want to
insert a single character in between a string in all 250 records. e.g. I have
"A1400" in one record and I want to make it "AI1400" , I have "P2566" and I
want to make it "PI2566". It will be better if it is done using query. Is
there any solution?
Click to expand...

If the new character is always "I" and you always want it in the second
position...

UPDATE TableName
SET FieldName = Left(FieldName, 1) & "I" & Mid(FieldName, 2)

(please test on a copy of your table)
 
Top