What would be the correct syntax for this statement.
AND DIXCOM.F0005.DRKY = right(' ' + DIXCUST.FDCASLD.CASR2, 10)

I use this in SQL 7 and it works great but not on the AS/400. What would be the correct syntax for AS/400 or a workaround.