>I have a Customer table that have 20 fields. I want to select 16 fields. Do I have to do this way?
>SELECT C.field1, C.field2,….. , C.field16 FROM Customer C where C.field1 = "whatever"
>
>Any ways?
>
>Thanks
>James

Two methods you can use for this are
a) select them all with '*' even if you're not using all of them just to make life easier
b) use the query designer to get the SQL code and copy/paste it to your pgm and modify as needed