[RESOLVED] Split string using asp.net 2.0 and ms access

[shyguyjeff]

Hello everyone.. I have a problem regarding splitting a string and that string has values on the table coming from ms access. Ex. I have "123456789" and it is coming from my database, how can i split that by 3 so that it will result into 123, 456 ,789 and that number has values on other tables but same fieldname. This is the following structure of my database.

First Table
Itemcode     ItemName
123456789      Potato Chips

Second Table:
ItemCode        BrandName
123                Mr.Chips
456                Lays
789                Cheetoos

This is what really i want, I need to get all those Brandname by getting the Itemcode on the first table and split it by three. Is there any query to make that or if it will be done using code, could anyone help me to get my problem solved?

Thank you in advance everyone and have a nice day.