Subject Re: [firebird-support] sql question
Author Milan Babuskov
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