REPLACE(my_column_name,"_"," ") will Do
MyColumnName - with this there is no literal if there as any you can use that replace function or if the string length always same then we can use FIND function along with Replace
Could you please add your sample data so that it will be easy to decipher
There really is no sample data. You can just use the string literals below if you have an idea you'd like to test.
I would like to see those as "First Name" and "Date Of Birth" respectively.