UPDATE wkouser SET SONO = Left([someField],5) ?
Always post what you tried if you can. It provides some context for those who would help you.
Unless you plan to split the info and delete the field this may be a non-issue - you can populate any form/report field with the parts, same as you could update a table field.
I answered on the basis that the number of characters in every record will always be as you posted. If not, you need something more robust.
In that case, for the left part you could use Trim(Val([someField]). The rightmost part would be more involved.
Last edited by Micron; 01-23-2022 at 07:45 PM.
Reason: added info
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.