flying sfo-mry on an emb-120 (at least 15 years ago), low fog and night, and when we emerged from the fog on landing, immediately went back up, pilot comes on and says, looks like we missed it that time, we'll try it one more time, and if we can't land we're going to have to go back to sfo. Circled around and landed.