Hi,

When building a dynamic query and concatenating a string with an integer data type parameter it fails when deploying the SP.

CREATE PROCEDURE CLI_DATA_SQL
( IN P_ACCNUM INTEGER)

DECLARE V_SQL VARCHAR(2000);
SET V_SQL = ' WHERE CS.DOCSTATUS = 1 AND CS.ACCNUM > ' || P_ACCNUM

This statement with a string data type works fine.
SET V_SQL = ' WHERE CS.DOCSTATUS = 1 AND CS.TRADENAME LIKE '''|| P_CMPNAME ||'%''';

The issue is how to connect my statement with a integer data type parameter?

Thanks in advance

Take a look at the CAST operator.

Hi Nick,

Works very well....

Thanks :-)