A table in SQLite DB contains 52 columns and their name as follows
**size0,size1,size2,size3,....size49,category,priority**.

while preparing the query for getting the values in only sizes columns i'm writing the query as

**select size0,size1,size2,size3,....size49 from myTableName**.

Can we prepare these column names **dynamically in a loop**( **because all size columns are in logical order** ) **within the query it self**?

and that **query should work in sqlite**.

Any comments or suggestions would be appreciated.

Thank you in advance.