pass partition name as parameter to sql query

[angro]

Hi,
The query

     select * from table_name partition (#prompt('part_name')#) [/i]

generates error during validation.

Any idea how to pass partition name to sql query? I have a very large table and it is partitioned by day (over 2 mln records) . I can use where  in query , but partition is much faster.

Regards