Is it what you mean:

Let us suppose that user selected "apr03" from the user dialog and the value is stored in the variable lcMonth.

sele * from ("pay"+lcMonth)...


>Hello
>
>In a client-server environment , how can retrieve data from tables by SQL
>
>eg i have payfiles like PayJan03,payFeb03,PayMar03 and if the user select Jan 03 .. Apr03 how can select the data by SQL into a temp table ?
>
>TIA