Array data type

Hi, all


Please help

Is it possible to create or use an array field type in sql 7/2000 as can be acheived in databases such as Oracle and Progress.


For example can the following or similar be done.

create table MarriedWomen(firstname char(20), surnames array(Name char(20), isMaidenName integer(1));


I have a work around at the moment which uses a comma seperated value type approach to store the array elements but this requires string processing to retreive individual values.


e.g surname "james 1, brown "

Is there an easier way to do this?

I would appreciate any comments from other who have had similar problems.





Thanks is advance,

Adrian