Sorry dwain .. data

INSERT INTO [Table]

SELECT 1234, 1, 'True', 'False', 'False', 2, 'False', 'False', 'False', 3, 'True', 'True', 'True', 4, 'False', 'False', 'False'

One other complication, looking to filter and...

Not an option at this point. Again it's from a form. The form was designed like a grid.

Any thoughts?

Celko- thanks for the response.

Archaic is right on the money.

Your guess is right on about the structure. I was wrong it's actually nvarchar(30) instead of...