ms sql 2008 I need to retrieve the first 3 values in a comma delimited list.
The value in the field can be A or A,B or A,B,C or A,B,C,D, up to 10 values
I want to return the first, second and third values separately to use in a join
this sort of works for the first value Left(tblAuctions.auction_discipline, CharIndex('','', tblAuctions.auction_discipline + '','')-1) as first
but no luck with the second or third