Here is my question.<BR><BR>Suppose you have a database with 100 different colomns and 100 different rows. The database keeps a record of people and what appliances they own. Say the rows are people and the colomns are appliances. Furthermore suppose that all the rest of the fields have one of 2 possible values (either own or no-own). How could one construct a select statement that would only look at one particular person and all the appliances that they own. So just to clerify the colomn headers are <BR>Person, Appliance 1, Appl. 2, Appl. 3, Appl. 4, Appl. etc...,<BR><BR>P.S. How can you display the colomn names without actually typing them out.<BR><BR>I hope this question is worth answering. But if it isn't, could you answer it anways, I am really having trouble with it.