[neilbyrne]

Not correct. With perhaps a few exceptions, only the FRAM recipient ships got the SQS-23. In fact, and I'm away from my library, I believe it was only the FRAM I's, all of which were GEARING Class that got the 23. There were a few GEARINGs, 33 SUMNERS and I believe a couple of FLETCHER DDEs that received the FRAM II conversion, but they did not get the 23. In those days the 23 was paired with the ASROC installation because it was thought, wrongly as it proved out, that the 23 could reliably detect out to ASROC's original range of 10,000 yards. And only FRAM I ships received ASROC.
I served in two FRAM Is, HENDERSON (DD-785) as an enlisted SM3, and BROWNSON (DD-868) as an ENS and JG. BROWNSON, or "BROWNEYE" as the crew called her, was an exception. In 1970, she was equipped with the first SQQ-23 (PAIR) and served as test ship for same the whole two years that I was aboard. PAIR was almost a whole new sonar. It had enormously better signal processing than the straight 23 and had a very capable passive side which the straight 23 did not. For me it was great; we did almost nothing but straight ASW ops for that whole two years. PAIR went on to be installed in the ADAMS, FARRAGUT and LEAHY Classes.
For the WWII ships that were not FRAMed, their sonars were upgraded as catch can and as $$$ were available. Many got the less capable SQS-29 as I recall, but a lot still had the 46V when they went to their reward. One possible exception here, and I'm guessing, is ships sold abroad under the Foreign Military Sales Program (FMS). A lot of SUMNERs and FLETCHERs went to FMS after they reached end of service life in the USN. In some FMS cases, if the buyer country wants upgrades and is willing to pay for them, it can happen, but this is on a case basis. In any case, in '71 when I went to ASW school, they were still teaching the 46V although only for a day or so. Kind of a, "You won't believe how far we've come" kind of thing.