SELECT [MONTH_ID] & 'X' AS Expr1
FROM DT_MONTH;
A result above it
200301X
A result is MS ACCESS

how can i do with DB2 Same a result above

SELECT [Coumn] & 'THIS IS STRING'
FROM X
This case to add string to Feild Data of Microsoft Access

What SQL Startment to do IN DB2 SQL

Please help me

Try this.

SELECT MONTH_ID||'X' AS Expr1 FROM DT_MONTH;

Error: [IBM][CLI Driver][DB2/NT] SQL0440N No function by the name "||" having compatible arguments was found in the function path. SQLSTATE=42884

Try this.
SELECT MONTH_ID concat 'X' AS Expr1 FROM DT_MONTH;

Hi,

The MONTH_ID is probably not character type field. So you shout convert non_character type to charater type because only character types can be concatenated.

Please try:
SELECT CHAR(MONTH_ID) CONCAT 'X' AS Expr1 FROM DT_MONTH;

Hope this works,
Grofaty

Thank you verymuch
i' just to learn DB2 and just to know to convert the feild before concat anything