I have one column that I would like to separate into two columns, breaking at a space and the space may be at a different location with each entry. I have attempted to query using both instr and charindex functions to split the column in sql. Neither of these options seem to work. I can use substr; however, that is not much value if I can't determine how many characters I should use in the substr function. Does anyone have a suggestion, or advice?
I'd appreciate any suggestions you may have.
Thanks.