Re: sql select from question

2003-02-24 Thread Veysel Harun Sahin
Thanks dread. Yes it can be done programmatically. But i try to do only with sql. I don't want to hardcode it. [EMAIL PROTECTED] wrote: On 24-Feb-2003 Veysel Harun Sahin wrote: Hello list, I want to select all the columns in a table except one column. Can I do this without writing all the c

RE: sql select from question

2003-02-24 Thread Don Read
On 24-Feb-2003 Veysel Harun Sahin wrote: > Hello list, > > I want to select all the columns in a table except one column. Can I do > this without writing all the column names to the query? For example > assume that I have table with the name table1 and there are 50 columns > in table1 with the

sql select from question

2003-02-24 Thread Veysel Harun Sahin
Hello list, I want to select all the columns in a table except one column. Can I do this without writing all the column names to the query? For example assume that I have table with the name table1 and there are 50 columns in table1 with the names col1, col2, col3.col50. To be able to sele