I’m constantly amazed by the lack of knowledge shown by some “experts” in various fields. A good example recently appeared on a mailing list for freelance consultants that I read. Someone posted a question how they could update all data in database table to ensure that all the values were in upper case. One (seriously!) suggested solution was:
Export to CSV, open in excel, make them uppercase & import back
Although, this expert did go on to admit:
I’m not sure if excel has that functionality, but I guess it does
Luckily, other people had already pointed out the obvious SQL solution before this got to the list.
It scares me that people are charging money for work that is obviously so completely outside their area of expertise.