Hi all, I just attended an interview, where I answered lot of questions, but struggled to answer only one. If I have a table which has a column gender, and I have only 'm' and 'f' in that, how to change all 'm's into 'f' and vise versa, with a single sql statement? Any thoughts? Sent on my BlackBerry® from Vodafone-- //www.freelists.org/webpage/oracle-l