+1 for delimited split 8K
be aware though that you are doing a 3 way Cartesian join so with 3 elements you are selecting 1 from 27 combinations, with 4 elements you would be selecting 1 from 56, with 10 elements you will be selecting 1 in 1000 so the performance will go down hill quickly.  If you have more than three fields then exponent will increase.  10 elements across 5 columns = 1 in 100000
HOWEVER:

If you have the opportunity to refactor your database to provide a proper 3NF form you will benefit greatly 🙂