Update Field

[Trevor G]

I have a table which is a download and it misses part of the year and I need to insert the missing 2 digits through every record.

002079/01/10/0000
002082/01/10/0000
002096/01/10/0000
002159/01/10/0000
002179/01/10/0000
002181/01/10/0000
002182/01/10/0000
002224/01/10/0000

I have highlighted in red 10 and it needs to say 2010

 

[namliam]

You looking for something like this?
Left(Yourfield,10) & "20" & Mid(yourfield,11)

 

[dbDamo]

Can you not use left and right trims, then perform a concatenation to enable you to add the "20" in???

EDIT - which is pretty much what namliam has suggested!!!

 

[Trevor G]

Thank you both,

I have just run a check and it works a treat.