Help with updating single char in char field

[alqsp]

Hi, I need help in updating the 39 character of a 40 char field:

update Tabaddr
set Addr(39th char only) = 0
where Addr_num = 4

Does anyone know how to make an update to just the one character in the Addr field? Something like Addr(39:1?

 

[tomschafer]

Check to see if your DB engine has the mid function....
update Tabaddr
set mid(addr,39,1)= 0
where Addr_num = 4

 

[rac2]

In SQL Server -

UPDATE Tabaddr
SET Addr = STUFF(Addr, 39, 1, '0')
where Addr_num = 4

In Access -

UPDATE tabaddr
SET Addr = Left(Addr, 38) & '0' & Right(Addr, 1)
where Addr_num = 4