need update query to split name field into first last mi
im changing the fields of a table to split the name field into first last mi fields. i want to get the first letter upper case. not sure how i do that. also not sure how to split the name also. can anybody help me with this?