I think it is going to take VBA to do it. I am not that good with SQL, so it may be possible using that in the query, but I doubt it.
You can certainly do it with VBA and you can also then manipulate the data if required. i.e. take out the Upper Case or move it to the first character etc.