pfd
Reputable Poster
I am having trouble with the SQL syntax to join F4211 to F4801. I am trying to join the RORN in F4211 to DOCO in F4801. I am trying to strip the ZEROES in RORN and then convert it to a numeric field and then join it to F4801.
I tried the syntax below but it is failing.
STRIP( F4211.SDRORN, LEADING, '0' ) = CONVERT( F4801.WADOCO, SQL_CHAR )
Would someone please help me with the syntax?
Thanks,
Matt
AS/400 V5R3, One World Xe B7333,SP23, Update 7
I tried the syntax below but it is failing.
STRIP( F4211.SDRORN, LEADING, '0' ) = CONVERT( F4801.WADOCO, SQL_CHAR )
Would someone please help me with the syntax?
Thanks,
Matt
AS/400 V5R3, One World Xe B7333,SP23, Update 7