Update Query Using Left()
Posted on 2015-01-20
I want to split a field in two but I got the first part working but can't seem to get the second half of the sql working
UPDATE MyTableName SET MyTableName.FirstPart = Left([Combo] & " ",InStr([Combo] & " "," ")-1);
The second part should contain the Right() but since the amount of data fluctuates I can't seem to get it right.
I tried using 2, and 28 respectively but that isn't consistant. What is is the first part I got here except too that if there are no "Characters" such as AB then leave it alone for the Left() (should be an IIF statement?) but lost on how to configure that one, then the rest should be on the Right()