Hi--
So do I understand correctly that you want to change some QSL_RCVD fields en masse?
Your select statement looks good. In English, No QSL or LOTW QSL Rcvd, QSO DATE in this millenium, VIA is not blank, and MODE is sideband.
MAKE A BACKUP!!!
Go to tools/advanced/database commands. Type (or copy and paste)
USE LOG
REPLACE QSL_RCVD WITH "R" FOR LOTW_RCVD<>'F' AND (MODE='SSB' or mode='USB' or mode='LSB') AND QSO_DATE>={^2000-01-01} AND NOT EMPTY(VIA) AND QSL_RCVD<>'F'
There is a video here:
https://youtu.be/5d5gyJVFQEs
Pse subscribe to our Youtube channel while you are there.
Tnx/73,
Dennis WN4AZY