WHERE SerialNum = C327R300516

UPDATE BackUp SET SerialNum = 'C327R300516' & Chr(13) 
WHERE (((BackUp.[SerialNum]) = 'C327R300516'));


SELECT BackUp.SerialNum
FROM BackUp
WHERE (((BackUp.SerialNum)='C327R300516'));

UPDATE BackUp SET SerialNum = Replace(BackUp.SerialNum, Chr(13), '')
WHERE (((BackUp.[SerialNum]) Is Not Null));


UPDATE BackUp SET SerialNum = Replace(BackUp.SerialNum, Chr(13), '')
WHERE BackUp.SerialNum = 'C327R300516' & Chr(13)



SELECT *
FROM BackUp
WHERE BackUp.ID = 48503;


UPDATE BackUp SET SerialNum = Replace(BackUp.SerialNum, Chr(13), '')
WHERE (((BackUp.ID)=48503));

UPDATE BackUp SET BackUp.SerialNum = "63984790A

Good Cause due 11/22"
WHERE (((BackUp.ID)=48503));