Search in multi value column on SQL

Hi Kin,

If you have this type of data:

UID_ADSGroup   MVA

aaaaaa                 a;b;c;d

bbbbbb                 c;d;e;f

(where the ; is actually the char(7) MVA delimeter)

You can convert it to this using the below SQL:

UID_ADSGroup   ParameterValue

aaaaaa                 a

aaaaaa                 b

aaaaaa                 c

aaaaaa                 d

bbbbbb                 c

bbbbbb                 d

bbbbbb                 e

bbbbbb                 f

Of course you should only need the select.  The declares/inserts are just to set up some test data.

That should get you started.

HTH, Barry.

Alternatively, you could use charindex.

e.g. charindex('b',MVA) <> 0

That will find rows that have 'b' in the MVA.

Thanks for the responses Barry, worked perfectly!