Forum Discussion
DimitrisGreece
Apr 16, 2021Copper Contributor
Delete all data after a symbol in a field.
Hello, I have MS-Access 2007. In a Table field called ODOS, at the end of some entries, there is the symbol "&" and other words or numbers after that. I want the Symbol "&" of each entry and any lett...
Woldman
May 19, 2021Iron Contributor
Maybe an UPDATE-query like this works:
UPDATE <<table>>
SET ODOS = Left(ODOS, Instr(ODOS, "&") - 1)
WHERE Instr(ODOS, "&") > 0;
UPDATE <<table>>
SET ODOS = Left(ODOS, Instr(ODOS, "&") - 1)
WHERE Instr(ODOS, "&") > 0;