Is there some way I can write a SQL select so that if a date field
contains a certain date it is changed to another date, but all the
other date fields remain the same?

In other words:

select name1, date1 from table

With (If date1 = 1/1/1950 then date1 = 2/2/1952) somehow embeded in the
SQL select.