|Subject||Re: Problem with query parameter|
--- In firstname.lastname@example.org, Helen Borrie <helebor@...> wrote:
>Sweet! I've never known for sure what the rules are about when the brackets are required....I usually just add them until it works, but I've never had to put them around a variable alone before. Thank you (again).
> Small but crucial: use of a variable's value in a parameter is an expression, so it needs brackets:
> where CLIENTNO = coalesce((:CLIENT_NO), CLIENTNO)