Question retrieving column's data

[siang_wu_id@yahoo.com]

somebody please help me....
i'm using vb.net 2008 and SQL Server 2008...

the case is :
----------------------------------------------------------
if i have data in one column like :
ASD654-100-CCCEEE4444-200-

what query can be used to get "CCCEEE4444" ????

 

[jmcilhinney]

Is all the data in the column in the same format? I'd say that the easiest way would probably be to retrieve all the data in the column and then use String.Split to break up a field value and index out the part you want from the resulting array.