question about the "where ... like ... " clause in SQL

From: Marcolm (Marcolm.19unpn_at_mail.codecomments.com)
Date: 07/23/04 

Date: Fri, 23 Jul 2004 12:43:10 GMT

I want to list all the products name of which begins with ":pdName".

parameterRow.setString("pdName",jTextField_pdName.getText());

queryDataSet_srchAll.setQuery(new
com.borland.dx.sql.dataset.QueryDescriptor(database_hsmng, "select *
from onSale where productName like :pdName" + "%"+";", parameterRow,
true));

Unfortunately, above code takes no effect and my heart sinks to the
benthal.
Anyone knows how can it be done?
Thanks in advance. 

--
Marcolm
------------------------------------------------------------------------
Posted via http://www.codecomments.com
------------------------------------------------------------------------