If you're trying to do what I think you are, then the answer is that you can't do it in SQL. First Normal Form for databases is that all records must have the same shape. That is, all of the rows have to have the same number of columns. Excel lets you violate this, because it's not a database application, but SQL Server won't let you violate First Normal Form. All of the rows must have the same number of columns.

You can get around this in a couple of ways.

* You could include NULL values for any additional columns

* You could store all of the features in a single column

* You could produce an XML document instead.

Drew