'select * from tablename where id ='|| colval1;

here colval1 is of type integer.when i write it like this it give complile
time error and when i write char(colval1) it give run time error
how can i append an integer value in a query.


Regards

Amit Singal




DB2 & UDB email list listserv db2-l LazyDBA home page