Sql Field Seperation...

[Scott D]

I am making significant changes to an in house application for our
company. The problem I have is when a group of checkboxes was
submitted in the old application each of the values was seperated by a
comma and the entire thing submitted to a single field in the DB. In
the new application I am wanting to convert the old information and
seperate those out into their own fields.

I am assuming I will use some sort of split method (of which I am not
familiar in VB.Net) and then do a comparison of strings and say if
"This text found" enter 1 into the bit field associated with each
check box? I have one field with up to 10 comma seperated values
being split into 10 seperate fields in the DB.

Thank you in advance if I have not been clear enough I will be happy
to clarify.

 

[Marina]

There is a Split method in the string class. It will return an array of
strings that are the result of the split. You can check the length of the
array, and traverse it, etc.