<div>
Thank you. I actually found another table in the database that already has it split that I was unaware of. Thank you!
</div>


<div>
<div class="content wysiwyg-content">
Hello Experts,<br />
<br />
I am using SyBase SQL Anywhere 10 and VS 2015 C#<br />
<br />
This is what I have<br />
ID &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;Employee &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SecurityLevel &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; Stores<br />
100 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;John Smith &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;100 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;,S1,S3,S12,<br />
<br />
<br />
This is what I want the result to be<br />
ID &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;Employee &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SecurityLevel &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Stores<br />
100 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;John Smith &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;100 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1<br />
100 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;John Smith &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;100 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3<br />
100 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;John Smith &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;100 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;12<br />
<br />
Essentially I want to Parse 1 record into 3 individual based on the Stores column
</div>
</div>


Hello Experts,

I am using SyBase SQL Anywhere 10 and VS 2015 C#

This is what I have
ID	     Employee	SecurityLevel	    Stores
100	     John Smith	100	                           ,S1,S3,S12,


This is what I want the result to be
ID	     Employee	SecurityLevel	Stores
100	     John Smith	100	                         1
100	     John Smith	100                         3
100	     John Smith	100                        12

Essentially I want to Parse 1 record into 3 individual based on the Stores column

Thank you. I actually found another table in the database that already has it split that I was unaware of. Thank you!

SQL Syntax Parsing one record into multiple

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.