You cant use a parameter in place of a field name. Its not quite find-and-replace.

Jason

Fabrício Fadel Kammer wrote:

> Hi all,
>
> I'm with another doubt here!
>
> Can't I use the NULL for parameters comparison like bellow?
>
> SELECT C.NOME FROM CUSTOMERS AS C WHERE :pCode IS NULL OR C.CODIGO =
> :pCode;
>
> In this situation I want to select all customers if the pCode parameter
> is NULL or just one customer if the :pCode parameter was informed.
>
> Thanks again,
>
> Fabrício F. Kammer
> Conchal/SP Brazil
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>

--
The information transmitted herewith is sensitive information intended only for use to the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon, this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.