Microsoft SQL Select query
I have a column in a ms Sql table that has the following records:
MyColumn : C1_xxx1,C2_xxx1,C3_xxx1,C1_xxx2,C1_xxx3,C3_xxx2  etc
It is a text column that containt strings that have the following format: "CY_mystring" where Y is a number from 1 to 5 ,followed by the'_' character then 'mystring' that can have any value.

Is there a way to make a select return this column ordered as following:
C1_xxx1
C1_xxx2
C1_xxx3
......
C1_xxxn
C2_xxx1
......
C2_xxxn
C3_xxx1
.......
C3_xxxn
etc

Ordered by the CY_ substring.

thank you

Microsoft SQL Select query
===

I have a column in a ms Sql table that has the following records:
MyColumn : C1_xxx1,C2_xxx1,C3_xxx1,C1_xxx2,C1_xxx3,C3_xxx2  etc
It is a text column that containt strings that have the following format: "CY_mystring" where Y is a number from 1 to 5 ,followed by the'_' character then 'mystring' that can have any value.

Is there a way to make a select return this column ordered as following:
C1_xxx1
C1_xxx2
C1_xxx3
......
C1_xxxn
C2_xxx1
......
C2_xxxn
C3_xxx1
.......
C3_xxxn
etc

Ordered by the CY_ substring.

thank you
