TSQL Challenge 78 - Parse single field into multiple fields

The challenge idea is taken from a problem discussed in the MSDN TSQL forum. The database field contains long string with data for Quantity and Parts. The challenge is to parse the data into separate (Quantity and Parts) fields for displaying in a report. The Quantity of Parts is placed before the hyphen (-) and the Part number after the hyphen. If there is more than one part, each part is separated by a semi-colon.

http://beyondrelational.com/puzzles/challenges/112/parse-single-field-into-multiple-fields.aspx