>and it replaced every single record's pr_addr1 with a blank and there were no pr_codes = to "".

Do this from the command window:

?'Kevin' = 'Kevin'
?'Kevin' = 'K'
?'Kevin' = ''

Thats why every record evaluates to .T. and is replaced. Use EMPTY() or == instead.