Hi,

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
.
.
end

It is the input parameter IN_INT that needs to be casted to varchar.

Anyone?

Thx,
Henrik


[Non-text portions of this message have been removed]