I should know how to do this...
I have a field that has two parts with a hyphen in the middle (data provided to us by a third party). I want to put the part to the left of the hyphen in one field (location - text) and the right (customer number) in another. The number of characters in the two parts varies.
How to I break it apart? Can I do it with a couple of queries? I have almost 600,000 records where I need to to this.