Join Number field to String field problem

newer · #1 (**permalink**) 04-08-09, 11:20

I have table X, Y, I want to join A (number) to B (String) to get C
SELECT C
FROM X, Y
WHERE A=INTEGER(B)

I get an error: [DB2/400 SQL] SQL0420- Character in CAST argument not valid.

Thanks

dav1mo · #2 (**permalink**) 04-08-09, 11:58

Apparently there is some non-numeric data in B. You could try the reverse as well strip(digits(a),l,'0') = b

Dave

Internet Services

Web Development

Digital Marketing

Consumer Tech