Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    32

    Unanswered: Join Number field to String field problem

    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

  2. #2
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5
    Apparently there is some non-numeric data in B. You could try the reverse as well strip(digits(a),l,'0') = b

    Dave

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •