Henrik Sitter wrote:

> I have a stored procedure with some input parameters, and one is an
> integer that I would like to convert/cast from integer to varchar. This
> casted value is used in a where clause:
>
> if (exists(select 1 from USED_TABLE where ((TABLENAME = 'tableOne') and
> (COLUMNNAME = 'colOne') and (COLUMNVALUE = :IN_INT)) )) then begin
>
> It is the input parameter IN_INT that needs to be casted to varchar.
>
> Anyone?

Have you tried: CAST(:IN_INT as varchar(33)) ?
How does DDL from USER_TABLE look like?

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