Seperate data before character into new fields!

[NikkoF]

Hello guys.I have another challenge.

I have this field in a table

6238370; 10456240; 10456669

I need to build a query which will break everything before '';'' into a seperate field.

NewFiled1:6238370
NewField2:10456240
NewField3:10456669

My idea was to creat a new field,import everything and then delete all data before the first available '';''
Then make a new one with the same command etc. The general idea is that i wll create enough fields to host the seperate data...

Anyone can help with the Query-Or a better way of making this happen?

Thank you in advance

[orange]

Review the Split() function. http://msdn.microsoft.com/en-us/libr...=vs.90%29.aspx