Thanks so much for that, that's been doing my head in all day.

My guesstimates are that this database, including indexes, will already amount to 1/2 terrabyte in size. Now if I included that schema for coping with arrays, god knows what...

Actually, a thought has just occurred, and I'll have to rely on your saged advice again.

Is there any way of turning these arrays into XML to store into SQL, which...

Mmmm, I think that I've pulled out all the data that I need into searchable fields. Worst comes to the worst, I can always create these child tables for...

Well there are existing databases with simple arrays of integers for example. The length of these arrays vary, some are 4 elements, others are 12, 32 or the extreme...

Unfortunately like most of us, I'm having to work with the tools provided. And in this case it's SQL server.

Having mulled it over, I think I will...

Thanks for that. I was mulling over the idea of including a text field into the record that contains the data in a comma delimited format.

My class can then...