--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...> wrote:

>
> 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)

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).