Henrik Sitter wrote:

> I tried the following at it seems to do the trick:
>
> if (exists(select 1 TABLENAME, COLUMNNAME, cast(COLUMNVALUE as Integer)
> from USED_TABLE
> where ((TABLENAME = 'ARTNR_SW_TABELL') and (COLUMNNAME =
> 'SW_ARTNR') and (COLUMNVALUE = :IN_SW_ARTNR)) )) then
> begin
> .
> .
> end

Here the Firebird did the conversion for you automatically.
It should work the same without CAST().

--
Milan Babuskov
http://fbexport.sourceforge.net