--- In firebird-support@yahoogroups.com, Lucas Franzen <luc@...> wrote:

>
>
> > idcount = null;
>
> [snip]
>
> > if (getid IS NOT NULL) then
> > begin
> > idcount = idcount + 1;
>
> If you initialize idocunt with NULL you can add whatever y<ou want it
> will stay null!
> Null is null (unknown), not zero.
>
> Luc.
>

SELECT ID, SEARCHCOUNT
FROM TBLONE
WHERE SEARCHTERM = :SEARCHTERM
INTO :getid, :idcount;