Maybe

Select coalesce(value,'EOF') from table where id = someidnumber into
someresult;

----- Original Message -----
From: "slalom91" <slalom91@...>
To: <firebird-support@yahoogroups.com>
Sent: Tuesday, April 10, 2007 3:25 PM
Subject: [firebird-support] Empty Result Set / NULL handing


>I had a stored procedure similar to the following:
>
> ----
> Select value from table where id = someidnumber into :variable;
>
> If (variable is null) then
> result = 'EOF'
> else
> result = variable;
>
> ----
> In FB 1.5 this was working when the result set was empty. However,
> with FB 2.0.1 it is not.
>
> Do I need to modify my syntax to be more compatible with FB 2.0.1? Is
> this a documented adjustment to FB 2?
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org 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
>
>
>
>