I have 2 columns colour,countof

Thanku...It worked for me bit how can i convert

colourColourCount

Green2

Amber2

Red2

to

Green Amber Red

2 2 2

Yes i want colours in first column and count in second column.

CREATE TABLE COLORS

(

COLORS NVARCHAR(100)

)

INSERT INTO COLORS VALUES '1 - Green = FHG'

INSERT INTO COLORS VALUES ' 2 - 3<...