Concatenation problem

[Brad Allison]

Okay, here is my SQL statement:

SELECT CLST + CLNO AS ClubID, CLNAME
FROM QS36F.CLUBLIST
ORDER BY CLST + CLNO

This is an ODBC dataadapter pulling info from a DB2 database (AS400). I get
the error of "SQL0402 -+ use is not valid."

How would I take the Columns CLST and CLNO, concatenate these to create one
field? What am I missing?

Thanks for the information.

Brad

 

[Miha Markic [MVP C#]]

Hi Brad,

It depends on the server.
Try with || instead of +.