I'm currently trying to create a View from a Table that does the following:
Table A
╔═════════════╦═══════════════╗
║ PART NUMBER ║ FILE NAME ║
╠═════════════╬═══════════════╣
║ PN0001-01 ║ FOO ║
║ PN0002-01 ║ BAR ║
║ PN0003-01 ║ FOO,BAR ║
║ PN0004-01 ║ BAR,FOO,FOB ║
╚═════════════╩═══════════════╝
To create
View B
╔═════════════╦═══════════════╗
║ PART NUMBER ║ FILE NAME ║
╠═════════════╬═══════════════╣
║ PN0001-01 ║ FOO ║
║ PN0002-01 ║ BAR ║
║ PN0003-01 ║ FOO ║
║ PN0003-01 ║ BAR ║
║ PN0004-01 ║ BAR ║
║ PN0004-01 ║ FOO ║
║ PN0004-01 ║ FOB ║
╚═════════════╩═══════════════╝
So, essentially, I need to take records from Table A and insert them into View B, where if the record from A has a LIKE '[,]' property, then that field is split into multiple records in B, depending on the number of times the ',' is present, with the text between each ',' being given its own record in View B.