UNTESTED; Maybe UPDATE tblMyTableName.LOCATION SET tblMyTableName.LOCATION = Ucase(Left([LOCATION],8)) & Mid([LOCATION],9)
Then again, your post is somewhat confusing. You say you want to update part of the data in the field, which also contains the field name? Having the field name as part of the value in that same field would be strange. Need I point out that you should try anyone's suggestions on copies of tables (or whatever is involved) as my signature suggests?
I'm understanding that you want to change Location : West Boundary to LOCATION : West Boundary; not LOCATION : WEST BOUNDARY
Last edited by Micron; 04-19-2017 at 03:36 PM.
Reason: clarification
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.