Divide String based on character. In this case a -
Using MS SQL 2000. I need to split a string into two parts based on the -. The parts will be divided by a '-'.
Example: IBM-001 would end up as 'IBM' and '001'
MICROSOFT-011 would end up as 'MICROSOFT' and '011'