Alias for column names : Urgent

Hi ,

I want alias names for my columns.

I'm writing query like this

inquiryBean.setQueryStatement("SELECT CDE AS "New Code", TXT AS "New Text" FROM TNR004_PY_METH");

But it is giving me an error because there is space between New and Code also double quote problem is there.

In short I don't know how to write this query statement ?

Can anybody help me ?

Thanks,

-priya

[435 byte] By [Priyam] at [2007-9-26 2:30:41]