SQL SELECT query

[xoxoxoxoxoxox]

I want to display all data from my table except first three colunms. Is there any way to use "select * " query to see all colunms except first three? I'll greatly appreciate any help. Thanks

[andyharman]

You can do it in front-end programming languages really easily (in .NET you would iterate through the relevent columns returned in a DataReader). It is really difficult to do within the database - you would have to dynamically construct a select statement based upon the table's column meta data X|. Generally, doing "select * from xxxx" or doing an insert without explicitely specifying each column is considered to be bad practice for production code.

[Krish KP]

Create a view on the table ignoring or selecting only those columns required then use "SELECT *" on the query

Regards KP