Replace a zero with a one

[DJN]

Hi all. I have some 20,000 records where the 6th character needs to be changed from a 0 to a 1. It is the 6th character every time. Any ideas greatly appreciated.


David

 

[smedvid]

Here is some psuedo code to try...

UPDATE Table1 SET Field2 = MID(Field2,1,5) & IIF(MID(Field2,6,1) = '0', '1', MID(Field2,6,1)) & MID(Field2,7);

SJM

Steve Medvid
"IT Consultant & Web Master"

http://users.erols.com/medvid/

 

[DJN]

Thanks Steve. Works a treat.

David