Question retrieving column's data

Joined
Oct 14, 2009
Messages
4
Programming Experience
1-3
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

VB.NET Forum Moderator
Staff member
Joined
Aug 17, 2004
Messages
14,378
Location
Sydney, Australia
Programming Experience
10+
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.
 
Top Bottom